system dsn with MS Access?

[lucas]

Hi,
I want to connect to an access database trough a system dsn. I used the
"Microsft Access Driver" to create the dsn (that's the driver I always
used in traditional ASP). I have the ODBC update installed. I'm not sure
what to put in my connection string. I put "Microsoft Access Driver" for
the driver but have never seen such a connection string.
This is my connection string:

strConnectionString = "DRIVER={Microsoft Access
Driver};SERVER=localhost;UID=sa;DATABASE=myAccessDB;";

I get this error message :
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

Any ideas?

 

[Paul Clement]

¤ Hi,
¤ I want to connect to an access database trough a system dsn. I used the
¤ "Microsft Access Driver" to create the dsn (that's the driver I always
¤ used in traditional ASP). I have the ODBC update installed. I'm not sure
¤ what to put in my connection string. I put "Microsoft Access Driver" for
¤ the driver but have never seen such a connection string.
¤ This is my connection string:
¤
¤ strConnectionString = "DRIVER={Microsoft Access
¤ Driver};SERVER=localhost;UID=sa;DATABASE=myAccessDB;";
¤
¤ I get this error message :
¤ ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
¤ found and no default driver specified

See if the following helps:

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForAccess

Just keep in mind that you may encounter some limitations with the ODBC driver for Access. Typically
the Jet OLEDB driver is recommended.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)