[Zope-DB] mxODBC Zope DB2 adapter - how to specify the current schema?

[M.-A. Lemburg]

Gergana Silvanova wrote:
> Dear all,
> 
> I'm using Zope with IBM DB2... the adapter which I use is mxODBC DA from eGenix... in the database connection string, I can specify DSN, UID, PWD and adapter-specific stuff....does someone know if there is a way to specify the current schema? I looked in the documentation, but did not find it.

The only way to do this would be in the connection string,
using additional parameters. Please consult the ODBC driver
documentation for available options.

FWIW, this page lists the options for the Linux DB2 ODBC driver:

http://www-03.ibm.com/servers/eserver/iseries/linux/odbc/guide/odbcproperties.html

This is the general documentation page for the driver:

http://www-03.ibm.com/servers/eserver/iseries/linux/odbc/guide/

> Until now I was using the Zope DBDA adapter from BlueDynamics, and I easily could specify the schema, together with the database, username and password, in the database connection.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jan 20 2006)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::