[Tracker-discuss] [issue577] PYODBC will not talk to Oracle under Windows 10.

[William Abdo]

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 <metatracker at psf.upfronthosting.co.za>
<http://psf.upfronthosting.co.za/roundup/meta/issue577>
_______________________________________________________