OK, thanks Andrew.How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
I am getting error when using that NonStop Sql in driver field, help is very much aooreciated.
On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
OK, thanks Andrew.How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
OK, thanks Andrew.How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
OK, thanks Andrew.How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
On Thursday, April 15, 2021 at 2:30:39 AM UTC+5:30, Bill Honaker wrote:
On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <udayred...@gmail.com> wrote:
On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote: >> OK, thanks Andrew.The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428
How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.
I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.
If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.pyodbc.Error: ('01S00;,'[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)
It's typically installed with an SPR or RVU, using Software Essentials.
is the error i am getting
code:
import pyodbc
usr = "xxx"
pas = "xxx"
conn = pyodbc.connect('DRIVER={NonStop ODBC/MX 3.6};SERVER=TCP:127.0.0.1/18000;UID=%s;PWD=%s' % (usr,pas))
cursor = conn.cursor()
same thing replacing server ip:port , username and pwd
On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <udayred...@gmail.com> wrote: >On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428OK, thanks Andrew.How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.
I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.
If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.
It's typically installed with an SPR or RVU, using Software Essentials.
On Thursday, April 15, 2021 at 2:30:39 AM UTC+5:30, Bill Honaker wrote:
On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <udayred...@gmail.com> wrote: >> >On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote: >> >> OK, thanks Andrew.
How can i get DRIVER={NonStop ODBC/MX 3.6} driver?The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428
It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.
I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.
If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.
It's typically installed with an SPR or RVU, using Software Essentials.
pyodbc.Error: ('01S00;,'[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)
is the error i am getting
code:
import pyodbc
usr = "xxx"
pas = "xxx"
conn = pyodbc.connect('DRIVER={NonStop ODBC/MX 3.6};SERVER=TCP:127.0.0.1/18000;UID=%s;PWD=%s' % (usr,pas))
cursor = conn.cursor()
same thing replacing server ip:port , username and pwd
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 91:05:29 |
Calls: | 6,658 |
Files: | 12,203 |
Messages: | 5,334,158 |