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.
nsodbc64.exe (HPNonStop(TM) ODBC/MX64) - click for sample code (Download)
odbcw64.exe (HPNonStop(TM) ODBC/MX64 3.4 Unicoded) - click for sample code (Download)
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.
- Open a putty with correct IP and login credentials.(Example as bellow)
- Connect using Correct credentials
- Type “MXCI”
- Set the Catalog name
- Set Schema name
- Call the query
Feel free to comment if you have any doubt or clarification