Hi there, I'm trying to connect to an Oracle 7.3 database through Zope using a 'Z ODBC Database Connection'. It's giving me an error saying: 'Invalid connection string: gsmInfo' I set up a DSN throught the Control Panel as follows: Data Source Name: gsmInfo SQL* Net Connect String: 2: UserId: testowner This is using the 'Oracle73 Ver 2.5' Driver. I also used the '32-bit ODBC TEST' that comes with Oracle and this connected to the database no problem after entering in a password. Has anyone got any clues or suggestions to the problem. Thanks in advance, Michael Gannon. XML Workshop.
That doesn't look like a valid connection string. Usually, the connect string is something like: user/password@sid At least using the normal Oracle interface. SID, which I assume would map to ODBC would be the datasource name defined in your tnsnames.ora file. You might try testowner/password@gsmInfo Or consult your ODBC docs on proper connect strings. Michael Gannon wrote:
Hi there,
I'm trying to connect to an Oracle 7.3 database through Zope using a 'Z ODBC Database Connection'. It's giving me an error saying: 'Invalid connection string: gsmInfo'
I set up a DSN throught the Control Panel as follows:
Data Source Name: gsmInfo SQL* Net Connect String: 2: UserId: testowner
This is using the 'Oracle73 Ver 2.5' Driver.
I also used the '32-bit ODBC TEST' that comes with Oracle and this connected to the database no problem after entering in a password.
Has anyone got any clues or suggestions to the problem.
Thanks in advance,
Michael Gannon. XML Workshop.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Ken Kinder 303.381.7631
participants (2)
-
Ken Kinder -
Michael Gannon