[Zope] Zope and Oracle ODBC

[Michael Gannon]

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/