According to the eGenix docs:
Please refer to the ODBC manuals of your ODBC manager and database for
the exact syntax of the DSN_string. It typically has these entries:
'DSN=datasource_name;UID=userid;PWD=password;' (case is important !).
So, you've got DSN lowercase...
On 4/16/06, John CORRY <[EMAIL PROTECTED]> wrote:
>
>
>
> Hi,
>
>
>
> I have downloaded the mxodbc product. I am using windows xp, python 2.4 and
> I am trying to log onto a visual foxpro database file. I have downloaded
> the visual foxpro driver. I use the following code:
>
>
>
> import mx.ODBC
>
> import mx.ODBC.Windows
>
> db =
> mx.ODBC.Windows.DriverConnect('dsn=c:/test/m2m/data/cost_grid.dbf')
>
> c = db.cursor()
>
>
>
> and I get the following error:
>
>
>
> Traceback (most recent call last):
>
> File "C:\Python24\Lib\site-packages\databasemanager.py",
> line 4, in ?
>
> db =
> mx.ODBC.Windows.DriverConnect('dsn=c:/test/m2m/data/cost_grid.dbf')
>
> OperationalError: ('IM002', 0, '[Microsoft][ODBC Driver Manager] Data source
> name not found and no default driver specified', 6044)
>
>
>
> What am I doing wrong and what do I need to do? Any help would be greatly
> appreciated.
>
>
>
> Thanks,
>
>
>
> John.
>
>
> _______________________________________________
> Tutor maillist - Tutor@python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>
>
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
