New submission from William Abdo:
PYODBC talk to Oracle under Windows 10.
I tried everything I could however, I was unable to make PYODBC talk to
Oracle 11g under Windows 10.
I have recently upgraded to Windows 10 and I have an issue with PYODBC
connecting to Oracle 11g.
It was working OK in Windows 7, till I upgraded to Windows 10.
I have tried setting it to Windows 7 compatibility mode .
I have updated the drivers to the latest (Which I think I already had).
Nothing works.
The actual error I get is
Traceback (most recent call last):
File "oraclecountsDec1.py", line 32, in <module>
pconnObj = pyodbc.connect( pconnString )
pyodbc.Error: ('NA000', "[NA000] [Microsoft][ODBC driver for
Oracle][Oracle]Error while trying to retrieve text for error ORA-01019 (1019)
(SQLDriverConnect); [01000] [Microsoft][ODBC Driver Manager] The driver doesn't
support the version of ODBC behavior that the application requested (see
SQLSetEnvAttr). (0)")
SQL Log file states:
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCX)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCX)(CID=(PROGRAM=D:\Python26\python.exe)(HOST=xxxxxxx-xxxxxxxx)(USER=xxxxxxxxxxxxxx))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 12.1.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
12.1.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows:
Version 12.1.0.2.0 - Production
Time: 06-AUG-2015 17:12:31
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: Message 12560 not found; No message file for product=NETWORK,
facility=TNS
ns secondary err code: 0
nt main err code: 530
TNS-00530: Message 530 not found; No message file for product=NETWORK,
facility=TNS
nt secondary err code: 126
nt OS err code: 0
----------
messages: 2994
nosy: wabdo
priority: bug
status: unread
title: PYODBC will not talk to Oracle under Windows 10.
_______________________________________________________
PSF Meta Tracker <metatrac...@psf.upfronthosting.co.za>
<http://psf.upfronthosting.co.za/roundup/meta/issue577>
_______________________________________________________
_______________________________________________
Tracker-discuss mailing list
Tracker-discuss@python.org
https://mail.python.org/mailman/listinfo/tracker-discuss
