[DB-SIG] Generating a list of DSN's?

Molina Carron ernesto.molina@externo.mju.es
Mon, 16 Dec 2002 10:49:57 +0100

have u installed mx.ODBC? Maybe you installed only the base package
Try "import mx.ODBC" and once you notice you haven't installed it, go to
http://www.egenix.com/files/python/eGenix-mx-Extensions.html#Packages and
download it

>>> import mx.ODBC
>>> mx.ODBC.Windows.DataSources()
{'menores_login': 'Controlador ODBC de Oracle', 'MS Access 97 Database':
'Microsoft Access Driver (*.mdb)', 'FoxPro Files': 'Microsoft FoxPro Driver
(*.dbf)', 'Text Files': 'Microsoft Text Driver (*.txt; *.csv)', 'SUN10000':
'Controlador ODBC de Oracle', 'menores_2': 'Controlador ODBC de Oracle',
'DESJUS': 'Controlador ODBC de Oracle', 'Excel Files': 'Microsoft Excel
Driver (*.xls)', 'DESMENORES': 'Controlador ODBC de Oracle', 'xx':
'Microsoft Access Driver (*.mdb)', 'FoxPro Files - Word': 'Microsoft FoxPro
VFP Driver (*.dbf)', 'menores': 'Controlador ODBC de Oracle', 'Visual FoxPro
Database': 'Microsoft Visual FoxPro Driver', 'MQIS': 'SQL Server', 'dBase
Files - Word': 'Microsoft dBase VFP Driver (*.dbf)', 'MS Access Database':
'Microsoft Access Driver (*.mdb)', 'ORAL': 'Controlador ODBC de Oracle',
'dBASE Files': 'Microsoft dBase Driver (*.dbf)', 'Visual FoxPro Tables':
'Microsoft Visual FoxPro Driver'}

----- Original Message -----
From: "Bob Gailer" <ramrom@earthling.net>
To: "M.-A. Lemburg" <mal@lemburg.com>; "guy robinson" <redarch@ihug.co.nz>
Cc: <db-sig@python.org>
Sent: Saturday, December 14, 2002 7:11 PM
Subject: Re: [DB-SIG] Generating a list of DSN's?

> >mx.ODBC.Windows.DataSources() ?
>  >>> import mx
>  >>> mx.ODBC.Windows.DataSources()
> Traceback (most recent call last):
>    File "<interactive input>", line 1, in ?
> AttributeError: 'module' object has no attribute 'ODBC'
> What am I missing?
> Bob Gailer
> mailto:ramrom@earthling.net
> 303 442 2625
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig