How can I connect to a sql/mp or sql/mx database on Nonstop using python.?
i have followed this to get the connection established to HP nonstop database, I am getting error as driver DRIVER={NonStop ODBC/MX 3.6} is not found.
Help is appreciated.
Asked
Active
Viewed 326 times
0
-
Can you confirm that you installed the driver following the procedures described in the [NonStop ODBC/MX Client Drivers User Guide](https://support.hpe.com/hpesc/public/docDisplay?docId=a00045523en_us&docLocale=en_US) and that you have version 3.6 not another version ? – Andy Simpson Apr 14 '21 at 22:09
-
I am working off the server and trying to connect to the NONSTOP Sql server, I am not able to get the driver, as shown in the user guid. I am unable to understand step 4.Use FTP to download the following files from the $SYSTEM.ZMXODBC installation subvolume:• ANSI TDMODBC or the Unicode ODBCW32 file for 32–bit driver install• ANSI NSODBC64 or the Unicode ODBCW64 file for 64–bit driver install – UDAY REDDY KAIPA Apr 16 '21 at 13:42
1 Answers
0
To connect the NonStop sql or for any relevant databases, a ODBC or JDBC driver is required.
From my experience JDBC works with JAVA only thought there are pyodbc and other python libs are available( they didn't work for me and they internally depends on java.)
Better to do it in java. In my case I called the java class from python using os level commands and result stored in excel which is read from python again.
Dharman
- 30,962
- 25
- 85
- 135
UDAY REDDY KAIPA
- 21
- 4