[egenix-users] Getting mxODBCZopeDA connector to pick-up
environment ODBC DNSs
charlie at egenix.com
Fri Sep 19 15:52:40 CEST 2008
Am 18.09.2008, 23:37 Uhr, schrieb <kw_dev_lists at contextualcorp.com>:
> I've got freetds and unixODBC working fine from the command line (tsql
> test, for example) on a server, but when I create an eGenix mxODBC
> connection in Zope 2.9 to an MS SQL Server database, it's not finding
> the environment connections (DSNs) defined in the ODBC.ini.
> What's the best way to get it to pick these settings up, so that when I
> click on 'Available Datasources' in the connection object, it'll show
> them and can connect to them?
> Should I add an environment variable ODBCINI= to the zope.conf file?
No, that isn't necessary. The usual problem with data sources, drivers and
the like is making sure that the permissions are correct, ie. so that the
Zope user can access them. When testing on the command line you will
normally be using your own user account.
Professional Python Services directly from the Source
>>> 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,MacOSX for free ! ::::
eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
More information about the egenix-users