Showing posts with label Could not find installable ISAM. Show all posts
Showing posts with label Could not find installable ISAM. Show all posts

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 \