i'm trying to connect Oracle Database with Oracle73 ver 2.5 ODBC driver through Zope; But it fails with a invalid connection string error. Is it possible Zope doesnt deal with userId and pwd request from Oracle ? Is it an other way to connect with Z (Aqueduct is not in add form) Thanks for your help Christian Martel
On 20 Jan 99, at 15:35, Christian Martel wrote:
i'm trying to connect Oracle Database with Oracle73 ver 2.5 ODBC driver through Zope; But it fails with a invalid connection string error. Is it possible Zope doesnt deal with userId and pwd request from Oracle ? Is it an other way to connect with Z (Aqueduct is not in add form)
What version of ZODBC do you have? Earlier versions could report this message depending on the result code of SQLConnect(). You may wish to re-download ZODBC and get the latest version, 3.03 if you don't already have it. Brad Clements, bkc@murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com ICQ: 14856937 We must come down from our heights, and leave our straight paths, for the byways and low places of life, if we would learn truths by strong contrasts; and in hovels, in forecastles, and among our own outcasts in foreign lands, see what has been wrought upon our fellow-creatures by accident, hardship, or vice. - Richard Henry Dana, Jr. 1836
Christian Martel wrote:
i'm trying to connect Oracle Database with Oracle73 ver 2.5 ODBC driver through Zope;
Oracles ODBC driver's stick. I know for a fact that the driver that comes with 8.0.4 leaks badly.
But it fails with a invalid connection string error. Is it possible Zope doesnt deal with userId and pwd request from Oracle ?
You need to include the user name and password in the connection string: dsn user password
Is it an other way to connect with Z (Aqueduct is not in add form)
Sure, use the Z Oracle DA. Of course, you'll have to build some extensions yourself. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (540) 371-6909 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
participants (3)
-
Brad Clements -
Christian Martel -
Jim Fulton