 | |
ORA-01017 error only with qt
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: ORA-01017 error only with qt -
01-08-2008
, 03:13 AM
|
thanks but Unfortunately, this won't fix since the database connection and the query must be executed from the Qt graphical user interface, that is to say after the qt application is launched. The script I've provided is just a simplify part of a big application, and this application works fine on windows, solaris and even on some other linux boxes ! bye laurent On 4 jan, 20:21, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com> wrote: labr... (AT) gmail (DOT) com wrote: Hi, I'm using the cx_oracle python module to access an oracle database It works fine but when I run within a qt environment it fails with the following error: ORA-01017: invalid username/password; logon denied The script that works: * * * * *import cx_Oracle as Oracle * * * * *import qt * * * * *sql_query * * * * * * *= "SELECT * FROM AC_DATATYPE" * * * * *dbUser * * * * * * * * = ... * * * * *dbPassword * * * * * * = ... * * * * *dbHostname * * * * * * = ... * * * * *dbInstance * * * * * * = ... * * * * *dbPort * * * * * * * * = ... * * * * *dbDSN *= Oracle.makedsn(dbHostname, int(dbPort), dbInstance) * * * * *#### app = qt.QApplication([]) * * * * *dbConnection = Oracle.connect(user=dbUser,password=dbPassword,dsn =dbDSN) The connection fails if the line * * * *#### app = qt.QApplication([]) is uncommented Not into python, but suspecting processing is serial, try to reverse the two last lines - you to try to process something without being logged on - the Oracle.connect must be doing that if everything works ok without the app = qt.... line. -- Regards, Frank van Bortel Top-posting is one way to shut me up...- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - |
#12
| |||
| |||
|
|
thanks but Unfortunately, this won't fix since the database connection and the query must be executed from the Qt graphical user interface, that is to say after the qt application is launched. The script I've provided is just a simplify part of a big application, and this application works fine on windows, solaris and even on some other linux boxes ! bye laurent On 4 jan, 20:21, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com> wrote: labr... (AT) gmail (DOT) com wrote: Hi, I'm using the cx_oracle python module to access an oracle database It works fine but when I run within a qt environment it fails with the following error: ORA-01017: invalid username/password; logon denied The script that works: * * * * *import cx_Oracle as Oracle * * * * *import qt * * * * *sql_query * * * * * * *= "SELECT * FROM AC_DATATYPE" * * * * *dbUser * * * * * * * * = ... * * * * *dbPassword * * * * * * = ... * * * * *dbHostname * * * * * * = ... * * * * *dbInstance * * * * * * = ... * * * * *dbPort * * * * * * * * = ... * * * * *dbDSN *= Oracle.makedsn(dbHostname, int(dbPort), dbInstance) * * * * *#### app = qt.QApplication([]) * * * * *dbConnection = Oracle.connect(user=dbUser,password=dbPassword,dsn =dbDSN) The connection fails if the line * * * *#### app = qt.QApplication([]) is uncommented Not into python, but suspecting processing is serial, try to reverse the two last lines - you to try to process something without being logged on - the Oracle.connect must be doing that if everything works ok without the app = qt.... line. -- Regards, Frank van Bortel Top-posting is one way to shut me up...- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - |
#13
| |||
| |||
|
|
thanks but Unfortunately, this won't fix since the database connection and the query must be executed from the Qt graphical user interface, that is to say after the qt application is launched. The script I've provided is just a simplify part of a big application, and this application works fine on windows, solaris and even on some other linux boxes ! bye laurent On 4 jan, 20:21, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com> wrote: labr... (AT) gmail (DOT) com wrote: Hi, I'm using the cx_oracle python module to access an oracle database It works fine but when I run within a qt environment it fails with the following error: ORA-01017: invalid username/password; logon denied The script that works: * * * * *import cx_Oracle as Oracle * * * * *import qt * * * * *sql_query * * * * * * *= "SELECT * FROM AC_DATATYPE" * * * * *dbUser * * * * * * * * = ... * * * * *dbPassword * * * * * * = ... * * * * *dbHostname * * * * * * = ... * * * * *dbInstance * * * * * * = ... * * * * *dbPort * * * * * * * * = ... * * * * *dbDSN *= Oracle.makedsn(dbHostname, int(dbPort), dbInstance) * * * * *#### app = qt.QApplication([]) * * * * *dbConnection = Oracle.connect(user=dbUser,password=dbPassword,dsn =dbDSN) The connection fails if the line * * * *#### app = qt.QApplication([]) is uncommented Not into python, but suspecting processing is serial, try to reverse the two last lines - you to try to process something without being logged on - the Oracle.connect must be doing that if everything works ok without the app = qt.... line. -- Regards, Frank van Bortel Top-posting is one way to shut me up...- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.