HP(Hewlett Packard) NonStop SQL/MX For .NET

WHAT CAN I USE TO CONNECT MY .NET CODE WITH SQL/MX ?

HP NonStop SQL is a database management system sold by HP(Hewlett Packard). To connect to SQL/MX, proper way would be connecting trough a ODBC connection. There are two ODBC driver setups you can use to connect with SQL/MX database.

  1. nsodbc64.exe (HPNonStop(TM) ODBC/MX64) - click for sample code (Download)
  2. odbcw64.exe (HPNonStop(TM) ODBC/MX64 3.4 Unicoded) - click for sample code (Download)

setup-files

Please Read my post How to create ODBC connection? to get to know what is ODBC and with example of how to create an ODBC connection

HOW TO CHECK DRIVER INSTALLATION SUCCESSFUL ?

We can verify this using a mxci and executing a sql query.

  1. Open a putty with correct IP and login credentials.(Example as bellow)putty-settings
  2. Connect using Correct credentials
  3. Type  “MXCI”
  4. Set the Catalog name
  5. Set Schema name
  6. Call the query

mxci

Feel free to comment if you have any doubt or clarification  

~Thank you~

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*