[egenix-users] Getting mxODBCZopeDA connector to pick-up environment ODBC DNSs

[Charlie Clark]

Am 18.09.2008, 23:37 Uhr, schrieb <kw_dev_lists at contextualcorp.com>:

> Hi,
>
> 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.

Charlie
-- 
Charlie Clark
eGenix.com

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