Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: William Abdo <william.abdo@verio.net>
Newsgroups: comp.lang.python
Subject: Windows 10 and PYODBC
Date: Wed, 9 Dec 2015 20:33:38 +0000
Lines: 92
Message-ID: <mailman.103.1449716969.12405.python-list@python.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Thread-Topic: Windows 10 and PYODBC
Thread-Index: AdEyvbibfzDFrJkoQ8W1mxan+WvXIA==
Accept-Language: en-US
Content-Language: en-US
received-spf: None (protection.outlook.com: verio.net does not designate permitted sender hosts)
spamdiagnosticoutput: 1:23
spamdiagnosticmetadata: NSPM
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Dec 2015 20:33:38.5330 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 281c3918-264a-4db4-ab20-2dafa1dca324
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM2PR0801MB0928
X-Content-Filtered-By: Mailman/MimeDel 2.1.20+
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.20+
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Xref: csiph.com comp.lang.python:100216

Hi All,
I am not sure if anyone has asked this question already or not but I will a=
gain.
Hopefully someone else has had and found a fix for this issue.
I'm grateful for any and all assistance.

I have recently upgraded to Windows 10 and I have an issue with PYODBC conn=
ecting to Oracle 11g.

It was working OK in Windows 7,  till I upgraded to Windows 10, Anyone have=
 any IDEAS?
I have tried setting it to Windows 7 compatibility mode .
I have updated the drivers to the latest (Which I think I already had).

The actual error I get is
 Traceback (most recent call last):
  File "oraclecountsDec1.py", line 32, in <module>
    pconnObj =3D  pyodbc.connect( pconnString )
pyodbc.Error: ('NA000', "[NA000] [Microsoft][ODBC driver for Oracle][Oracle=
]Error while trying to retrieve text for error ORA-01019 (1019) (SQLDriverC=
onnect); [01000] [Microsoft][ODBC Driver Manager] The driver doesn't suppor=
t the version of ODBC behavior that the application requested (see SQLSetEn=
vAttr). (0)")

SQL Log file states:
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DBEQ)(PROGRAM=3Doracle)(ARGV0=3Doracle=
ORCX)(ARGS=3D'(DESCRIPTION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Dbeq)))'))(=
CONNECT_DATA=3D(SID=3DORCX)(CID=3D(PROGRAM=3DD:\Python26\python.exe)(HOST=
=3Dxxxxxxx-xxxxxxxx)(USER=3Dxxxxxxxxxxxxxx))))

  VERSION INFORMATION:
                TNS for 32-bit Windows: Version 12.1.0.2.0 - Production
                Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Ver=
sion 12.1.0.2.0 - Production
                Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: V=
ersion 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=3DNETWO=
RK, facility=3DTNS
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Message 530 not found; No message file for product=3DNETWORK=
, facility=3DTNS
    nt secondary err code: 126
    nt OS err code: 0


Respectfully,

William Abdo
Software App Engineer II
NTT America, an NTT Communications Company
Office:   +1 561.912.2434
Email:    w.abdo@ntta.com<mailto:w.abdo@ntta.com>
[https://rvip.team-center.net/externals/images/email/ntta.png]<http://www.u=
s.ntt.com/index.html>
[https://rvip.team-center.net/externals/images/email/ntta-twitter.png]<http=
://www.twitter.com/NTT_America>  [https://rvip.team-center.net/externals/im=
ages/email/ntta-linkedin.png] <http://www.linkedin.com/company/ntt-america>=
   [https://rvip.team-center.net/externals/images/email/ntta-facebook.png] =
<http://www.facebook.com/nttamerica>   [https://rvip.team-center.net/extern=
als/images/email/ntta-youtube.png] <http://www.youtube.com/user/NTTCommunic=
ationsEN>








________________________________
This email message is intended for the use of the person to whom it has bee=
n sent, and may contain information that is confidential or legally protect=
ed. If you are not the intended recipient or have received this message in =
error, you are not authorized to copy, distribute, or otherwise use this me=
ssage or its attachments. Please notify the sender immediately by return e-=
mail and permanently delete this message and any attachments. makes no warr=
anty that this email is error or virus free. Thank you.
________________________________
This email message is intended for the use of the person to whom it has bee=
n sent, and may contain information that is confidential or legally protect=
ed. If you are not the intended recipient or have received this message in =
error, you are not authorized to copy, distribute, or otherwise use this me=
ssage or its attachments. Please notify the sender immediately by return e-=
mail and permanently delete this message and any attachments. NTT America m=
akes no warranty that this email is error or virus free. Thank you.
________________________________