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

[M.-A. Lemburg]

On 2008-09-19 20:02, kw_dev_lists at contextualcorp.com wrote:
> I have freetds and unixODBC under /usr/lib/zopeODBC and these folders are owned 
> by the same user:group that my zope instance is owned by and that zope runs under.
> 
> The mxODBC connector doesn't seem to be able to find the drivers under 
> /user/lib/zopeODBC/unixODBC or .../freetds.
> 
> Do I need to add an PATH environment variable to zope.conf or something, so 
> these can be found?
> 
> Here's the error from the zope event.log:
> 
> ------
> 2008-09-19T12:56:24 ERROR Zope Couldn't install mxODBCZopeDA
> Traceback (most recent call last):
>   File "/usr/local/apps/zope/core/Z298/lib/python/OFS/Application.py", line 755, 
> in install_product
>   File "Products/mxODBCZopeDA/__init__.py", line 7, in ?
>     # Version 2.1 (ZPL).  A copy of the ZPL should accompany this distribution.
>   File "Products/mxODBCZopeDA/ZopeDA.py", line 254, in ?
>   File "Products/mxODBCZopeDA/ZopeDA.py", line 246, in find_subpackages
> ImportError: no usable mxODBC subpackage found: iODBC: libiodbc.so.2: cannot 
> open shared object file: No such file or directory; unixODBC: libodbc.so.1: 
> cannot open shared object file: No such file or directory

mxODBC cannot load the unixODBC manager shared libraries.

You will either have to add the path to these to your system
configuration file ld.so.conf or setup LD_LIBRARY_PATH to
include them.

Regards,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Sep 22 2008)
>>> 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


> ------
> 2008-09-19T12:56:24 INFO Zope Ready to handle requests
> ------
> 2008-09-19T12:56:25 WARNING ZODB Could not import class 'ZopeConnection' from 
> module 'Products.mxODBCZopeDA.ZopeDA'
> 
> 
> Thanks,
> Ken
> 
>     -------- Original Message --------
>     Subject: Re: [egenix-users] Getting mxODBCZopeDA connector to pick-up
>     environment ODBC DNSs
>     From: "Charlie Clark" <charlie at egenix.com>
>     Date: Fri, September 19, 2008 5:52 am
>     To: kw_dev_lists at contextualcorp.com, egenix-users at egenix.com
> 
>     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
> 
> 
> ------------------------------------------------------------------------
> 
> 
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> https://www.egenix.com/mailman/listinfo/egenix-users