locked
could not find installable isam Please Help RRS feed

  • Question

  • User1416899935 posted

    Hi,

    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:

    <appSettings>

      <add key="connectionStr" value="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Users\master\Documents\Visual Studio 2010\WebSites\WebSite4\App_Data\db.accdb"/>

    </appSettings>

    C#:

    string connectionStr = ConfigurationManager.AppSettings["connectionStr"];

    OleDbConnection connectObj=new OleDbConnection(this.connectionStr);

    //this part is the problem , when i try to open connectObj..

    connectObj.open();

    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.

    Tuesday, November 15, 2011 10:56 AM

Answers

  • User-1199946673 posted

    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

    http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 16, 2011 9:08 AM
  • User3866881 posted

    Hello takzam:)

    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:

    http://www.microsoft.com/download/en/details.aspx?id=13255

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 16, 2011 9:12 PM

All replies

  • User-1199946673 posted

    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

    http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 16, 2011 9:08 AM
  • User3866881 posted

    Hello takzam:)

    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:

    http://www.microsoft.com/download/en/details.aspx?id=13255

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 16, 2011 9:12 PM