[egenix-users] Error message: ('08003', 0, '[unixODBC][Driver Manager]Connnection does not exist', 7920)

[M.-A. Lemburg]

[Please always CC the egenix-users mailing list - other users may
 have run into similar problems]

Gianluca Mattiuzzi wrote:
> Hello,
> I use a System DSN located in /etc/odbc.ini, ODBC 2.2.11, Oracle 10g and
> Oracle Client for ODBC driver.
> Yesterday I tried to remove unixODBC and install it in the same
> directory of Zope with the owner permissions for zope user, but I have
> the same problem.

Rereading the error message, this sounds a lot like a known problem:

http://mail.easysoft.com/pipermail/unixodbc-support/2005-October/000739.html
http://mail.easysoft.com/pipermail/unixodbc-support/2005-October/000742.html
http://mail.easysoft.com/pipermail/unixodbc-support/2005-October/000743.html

The cause is a permission problem with the libraries needed
by the ODBC driver. Unfortunately, the error message is not
very accurate and misleads into thinking that the data source
definition cannot be found.

Running unixODBC with ODBC tracing enabled will show the error
message that relates to the specific library which cannot be
opened.

> M.-A. Lemburg ha scritto:
>> Gianluca Mattiuzzi wrote:
>>  
>>> Hello,
>>> I have a problem with egenix mxODBC Database Connection.
>>> If Oracle via ODBC  with
>>> "isql -n <DSN_NAME> <USER> <PASSWORD>"
>>> the result is
>>> Connected !
>>>
>>> But, if I try to connect with the same DSN_NAME, USER and PASSWORD in
>>> Zope via mxODBC Database Connection the result is
>>>
>>> *EGENIX.COM mxODBC Zope DA*
>>>
>>> Problem connecting to the database
>>>      Connection string: DSN=DBTEST<br> <br> Connection pool entry: 0<br>
>>> <br> Error message: ('08003', 0, '[unixODBC][Driver Manager]Connnection
>>> d<br> oes not exist', 7920)
>>>
>>>
>>> Can anyone help me?
>>>     
>>
>> Please make sure that the DSN is a "System Data Source" and/or
>> accessible by the Zope service process.
>>
>>   
> 

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Nov 30 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 ! ::::