Thursday, December 3, 2009

The On Demand Global Workforce - oDesk


Could not find installable ISAM when connecting with ms access

This error is common error when you use access database with asp.net. One of reason is bad connection string

I had this error and i have wasted more than 24 hours to find solution. This solution is get luck for me

Connection string for MS Access via ODBC:
"DSN=MS Access Database;UID=admin;PWD=;
SystemDB=C:\\data\\System.mdw;SafeTransactions = 0;
FIL=MS Access;DriverID = 25;DBQ=C:\\data\\train33.mdb"
Another connection string for MS Access via ODBC:
"Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\\Work\cvs_root\\log4net-1.2\\access.mdb;UID=;PWD=;"
Connection string for MS Access via OLE DB:
"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\\Work\\cvs_root\\log4net-1.2\\access.mdb;User Id=;Password=;"

 *** if you use c# dont forget to use \\ instead of \