[New-bugs-announce] [issue25875] PYODBC 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

----------
components: Windows
messages: 256482
nosy: paul.moore, steve.dower, tim.golden, wabdo, zach.ware
priority: normal
severity: normal
status: open
title: PYODBC  talk to Oracle under Windows 10.
versions: Python 2.7

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue25875>
_______________________________________