Hi there, Thanks all for your help. I got it working by keeping my old configuration in the ODBC Control Panel settings and using 'gsmInfo testowner PASSWORD' as the connect string in Zope. Cheers, Michael. Paul Browning wrote:

...

Message: 5 Date: Wed, 22 Mar 2000 19:39:45 +0000 From: Michael Gannon <mgannon@xmlw.ie> Organization: XML Workshop To: zope@zope.org Subject: [Zope] Zope and Oracle ODBC

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.

Not really. Just to confirm that it can be done. You've got TNSNAMES.ORA sorted OK? Does your Oracle database feature the SCOTT/TIGER tables? I find those useful for getting started.

Paul

-- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bris.ac.uk URL: http://www.bris.ac.uk/