Re: [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 stuffdoes 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 ! 
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

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

[Gergana Silvanova]

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 stuffdoes someone know if there is a way to specify the current schema? I looked in the documentation, but did not find it.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.Thanks in advance for the help,Gergana Silvanova
	
		Yahoo! Photos 
Got holiday prints? See all the ways to get quality prints in your hands ASAP.___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db