Hi Paul Hermeneutic,
The issue was it could not establish a connection , it threw an error
ORA-01019 (1019) .
So after some research it began to look like it was unable to connect via the
TNS Names. I was unable to verify this since it was just dying and not logging
the issue.
So I started a search for an Oracle based ODBC client since PYODBC is still
working with the Microsoft DB’s, I tried cx_Oracle and it worked perfectly
after I managed to get the parameters correct on the call,
It utilized all the syntax for the most part of PYODBC calls so only the
connection information needed to be altered.
Using parts of a snippet found on the internet that helped me.
Since I still needed PYODBC to talk to SQL Server I found that it worked best
if cx_Oracle’s import statement is Place before other ODBC clients. At least it
appeared that way to me in my testing.
See Below:
import cx_Oracle #Place before other ODBC Clients
pconnObj = cx_Oracle.connect('User/Password@TNSname') #replace with your
settings
pcur = pconnObj.cursor()
if pcur.execute('select * from dual'):
print "Yeah, it works!!!"
else:
print "Failure"
pcur.close()
I named the cursor the same as I had with PYODBC and no other changes were
necessary
.fetchall()
.fetchone()
All worked
Returnd values requested also as PYODBC did:
prows = pcur.execute("SELECT name,TableID,LastAlteredDate FROM myTable where
tableType = '1' order by name").fetchall()
print "#rows=" + str(len(prows)) + '\n'
tscnt = len(prows)
Good Luck!
If you have more questions just ask.
Respectfully,
William Abdo
Software App Engineer II
NTT America, an NTT Communications Company
Office: +1 561.912.2434
Email: w.a...@ntta.com<mailto:w.a...@ntta.com>
[https://rvip.team-center.net/externals/images/email/ntta.png]<http://www.us.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/images/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/externals/images/email/ntta-youtube.png]
<http://www.youtube.com/user/NTTCommunicationsEN>
From: paul.hermeneu...@gmail.com [mailto:paul.hermeneu...@gmail.com]
Sent: Tuesday, December 15, 2015 10:43 AM
To: William Abdo
Cc: python-list@python.org
Subject: RE: Windows 10 and PYODBC
On Dec 13, 2015 7:20 AM, "William Abdo"
<w.a...@ntta.com<mailto:w.a...@ntta.com>> wrote:
>
> Problem Resolved.
> I have fixed the Oracle connection issue under Windows 10 with cx_Oracle .
> PYODBC was only failing on the Oracle connection and worked fine on MS SQL
> under Windows 10.
Please tell us what the fix is. Thanks.
****************************************************************
This email message is intended for the use of the person to whom it has been
sent, and may contain information that is confidential or legally protected. 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 message or its
attachments. Please notify the sender immediately by return e-mail and
permanently delete this message and any attachments. NTT America makes no
warranty that this email is error or virus free. Thank you.
****************************************************************
--
https://mail.python.org/mailman/listinfo/python-list
