eGenix Software user-discussion (developers of the mx modules for python)

headers Volodymyr Cherepanyak | 13 Nov 2006 17:41

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

Volodymyr Cherepanyak wrote:
> Hi,
> 
> I have issue with reading data from MS Access .mdb  file on linux. Column
> names are not present in select results, integer data miss represented.
> 
> Col0
> 3158067
> 3486259
> 
> but in isql the same query returns:
> 
> item_qty
> 300
> 325
> 
> the item_qty type is Integer
> 
> Configuration: Zope 2.9.5, Python 2.4.3., mxODBCDA (
> egenix-mxodbc-zopeda-1.0.10.linux-i686-py2.4_ucs2.zip ), FedoraCore 4,
> unixODBC 2.2.11-3, mdbtools-20051217-1

This looks like a problem with the mdbtools ODBC driver having
problems with returning integer values.

Note that isql fetches all data as strings, while mxODBC uses
the data types that the ODBC driver announces for each column.

You might want to try the connection option 'Fetch short integers
as integers ?'.

If that doesn't help, there's not a lot we can do. While we do
try to support as many different ODBC drivers as possible,
we still have to rely on them providing working interfaces.

Regards,
--

-- 
Marc-Andre Lemburg
eGenix.com

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

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

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 29 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 ! ::::

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

[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 ! ::::

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

Mon	Tue	Wed	Thu	Fri	Sat	Sun

		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

3	May 2013
9	April 2013
6	March 2013
6	February 2013
2	December 2012
6	November 2012
2	October 2012
4	September 2012
28	August 2012
1	July 2012
3	June 2012
3	May 2012
10	April 2012
4	March 2012
6	February 2012
14	January 2012
13	December 2011
2	November 2011
2	September 2011
10	August 2011
3	July 2011
1	June 2011
13	May 2011
3	April 2011
3	March 2011
3	February 2011
8	January 2011
4	December 2010
3	November 2010
3	September 2010
9	August 2010
1	July 2010
12	June 2010
7	May 2010
30	April 2010
10	March 2010
16	February 2010
7	January 2010
8	December 2009
8	November 2009
7	September 2009
16	August 2009
19	July 2009
13	June 2009
10	May 2009
12	April 2009
20	March 2009
26	February 2009
22	January 2009
13	December 2008
12	November 2008
5	October 2008
26	September 2008
1	August 2008
11	July 2008
15	June 2008
36	May 2008
12	April 2008
4	February 2008
4	January 2008
21	November 2007
39	October 2007
9	September 2007
48	August 2007
13	July 2007
5	June 2007
16	May 2007
14	April 2007
27	March 2007
8	February 2007
21	January 2007
13	December 2006
5	November 2006
18	October 2006
7	September 2006
4	August 2006
13	July 2006
11	June 2006
5	May 2006
8	April 2006
1	March 2006
2	February 2006
17	January 2006
17	December 2005
13	November 2005
21	October 2005
12	September 2005
17	August 2005
2	July 2005
10	June 2005
21	May 2005
9	April 2005
24	March 2005
34	February 2005
46	January 2005
17	December 2004
21	November 2004
59	October 2004
6	September 2004
13	August 2004
11	July 2004
18	June 2004
22	May 2004
23	April 2004
22	March 2004
14	February 2004
23	January 2004
5	December 2003
11	November 2003
26	October 2003
15	September 2003
22	August 2003
22	July 2003
9	June 2003
8	May 2003
7	April 2003
6	March 2003
7	February 2003
10	January 2003
19	December 2002
9	November 2002
18	October 2002
41	September 2002
28	August 2002
17	July 2002
15	June 2002
4	May 2002
21	April 2002
1	March 2002
8	February 2002
3	January 2002

Integer data issues with MS Access

Re: Integer data issues with MS Access

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

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

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


	Connection string: DSN=DBTEST Connection pool entry: 0 Error message: ('08003', 0, '[unixODBC][Driver Manager]Connnection d oes not exist', 7920)