[Tutor] Difficulty connecting with odbc drivers

[John Corry]

Liam,

Thanks for the quick response.  I have changed the code so that dsn is now
DSN.  However I get the same error.

Any other thoughts?

Regards,

John.

-----Original Message-----
From: Liam Clarke [mailto:ml.cyresse at gmail.com]
Sent: 15 April 2006 15:02
To: john.corry at ntlworld.com
Cc: tutor at python.org
Subject: Re: [Tutor] Difficulty connecting with odbc drivers


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 <john.corry at ntlworld.com> 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 at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>
>