Current Web URL
Hi All,
I have been breaking my brains to find a solution to determining what
the current URL is in a web browser navigation bar.
It cannot be a prefixed values since I will not know what platform it is
running from at the time it is opened by the users.
Can this URL be extracted from the navigation bar so it can be parsed?
I tried this "response =
urllib2.urlopen('http://www.google.com').geturl()" however it seems to
always to give me the google url and not the one in the navigation bar.
Any Suggestions Please?
Respectfully,
William Abdo
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. Verio, Inc. makes no
warranty that this email is error or virus free. Thank you.
--
http://mail.python.org/mailman/listinfo/python-list
Windows 10 and PYODBC
Hi All,
I am not sure if anyone has asked this question already or not but I will again.
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
connecting 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
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=xxx-)(USER=xx
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
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>
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. makes no warranty 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 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
RE: Windows 10 and PYODBC
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. Thank You for your time in this matter. 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> 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
RE: Windows 10 and PYODBC
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"
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
RE: Windows 10 and PYODBC
Yes Paul Hermeneutic , that is correct. I tried everything I could however, I was unable to make PYODBC talk to Oracle under Windows 10. Maybe there are smarter than me that can make this work. For me it was easier to just use cx_Oracle for the Oracle connection. 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 11:34 AM To: William Abdo Cc: python-list@python.org Subject: RE: Windows 10 and PYODBC On Dec 15, 2015 9:22 AM, "William Abdo" mailto:w.a...@ntta.com>> wrote: > > 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 sounds like PYODBC cannot connect to Oracle on Windows 10. Is that correct? 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
RE: Windows 10 and PYODBC
As you wish, [issue577] PYODBC will not talk to Oracle under Windows 10. 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 1:41 PM To: William Abdo Cc: python-list@python.org Subject: RE: Windows 10 and PYODBC On Dec 15, 2015 10:34 AM, "William Abdo" mailto:w.a...@ntta.com>> wrote: > > Yes Paul Hermeneutic , that is correct. > > I tried everything I could however, I was unable to make PYODBC talk to > Oracle under Windows 10. It would be of help to everyone if you would file a bug report on the issue tracker. http://bugs.python.org/ 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
RE: Windows 10 and PYODBC
issue 25875 created I put it in the wrong area the first time. First time bug tracker user errors. 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 3:09 PM To: William Abdo Cc: python-list@python.org Subject: RE: Windows 10 and PYODBC On Dec 15, 2015 12:00 PM, "William Abdo" mailto:w.a...@ntta.com>> wrote: > > As you wish, > > [issue577] PYODBC will not talk to Oracle under Windows 10. Where is this issue filed? I do not see it on http://bugs.python.org/ 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
