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 \
No comments:
Post a Comment