[Zope] Zope and Oracle ODBC

[Ken Kinder]

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