You have to set the corresponding environment variables on the client side. Setting $ORACLE_SID might be sufficient. Check your Oracle docs for details. -aj ----- Original Message ----- From: "Klaus Boehm" <k.boehm@ewt.de> To: "zope-request@zope.org" <zope@zope.org> Sent: Wednesday, August 21, 2002 16:14 Subject: [Zope] oracle Database Connection

I have installed the oracle database adapter. now i try to connect to a oracle database.

i do "user_name/password@server_name"

but where can i select the database ?

we have on the server 9 different oracle databases.

thanks for helping.

klaus

--

ewt gmbh data management group tel: ++49 821 3106 319 fax: ++49 821 3106 399 url: www.ewt.de

_______________________________________________ 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 )

Klaus Boehm wrote:

I have installed the oracle database adapter. now i try to connect to a oracle database.

i do "user_name/password@server_name"

but where can i select the database ?

we have on the server 9 different oracle databases.

thanks for helping.

klaus

you connect to your oracle-databases via tnsnames. specify your database-connectors in Orcacle's tnsnames.ora. under linux: OraHome/network/admin/tnsnames.ora then use the tnsname to connect to your Oracle from Zope! user/password@tnsname cheers, maik -- Maik Jablonski __o www.zfl.uni-bielefeld.de _ \<_ Deutsche Zope User Group Bielefeld, Germany (_)/(_) www.dzug.org