Last post Nov 16, 2011 09:12 PM by Decker Dong - MSFT
Nov 15, 2011 10:56 AM|takzam|LINK
i am getting this message "could not find installable isam" when i am debugging my Application what could it be?
i think it has to do something with the connection string ..
this is the code i wrote:
<add key="connectionStr" value="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Users\master\Documents\Visual Studio 2010\WebSites\WebSite4\App_Data\db.accdb"/>
string connectionStr = ConfigurationManager.AppSettings["connectionStr"];
OleDbConnection connectObj=new OleDbConnection(this.connectionStr);
//this part is the problem , when i try to open connectObj..
maybe i didnt wrote it properly ..i think that "value" in <appSettings> is not right...
the code that i wrote is not full .. i just copied the important ones.
Nov 16, 2011 09:08 AM|hans_v|LINK
When using accdb files (Access 2007 and above), you'll need to use the ACE.OleDb.12.0 driver instead of the Jet.OleDb.4.0 driver, which only supports .mdb files (Access 2003 and lower).
Note that this driver is not by default installed on any Windows system, so you need to make sure that this driver is available on your production machine, otherwise convert your database to an Access 2003 (.mdb) file, and it will work.
By the way, instead of using the full path (which most likely will be different on a production machine), you can use the DataDirectory Directive
Nov 16, 2011 09:12 PM|Decker Dong - MSFT|LINK
My addition to hans_v——
1）You can move your accdb database out of "user", sometimes maybe it won't let you access directly the file there because there'll be a prermission...
I suggest you removing it to something like D:\folder\……
2）Just like what hans_v's said, plz download and install the driver at: