Re: [Tutor] Difficulty connecting with odbc drivers

2006-04-15 Thread Bob Gailer
John Corry wrote: > Liam, > > Thanks for the quick response. I have changed the code so that dsn is now > DSN. However I get the same error. I agree with Alan.the dsn should point to a data source rather than a file. To be more precise Start -> Settings -> Control Panel -> Administrative Tools

Re: [Tutor] Difficulty connecting with odbc drivers

2006-04-15 Thread Alan Gauld
> I have downloaded the mxodbc product. I am using windows xp, python 2.4 > 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 doin

Re: [Tutor] Difficulty connecting with odbc drivers

2006-04-15 Thread John Corry
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

Re: [Tutor] Difficulty connecting with odbc drivers

2006-04-15 Thread Liam Clarke
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 <

[Tutor] Difficulty connecting with odbc drivers

2006-04-15 Thread John CORRY
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(

[Tutor] Difficulty connecting with odbc drivers

2006-04-15 Thread John CORRY
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(