locked
Error connecting to MS-Access with oledb RRS feed

  • Question

  • User-132834496 posted

    Hi, When I am trying to connect to ms-access using oledb I am getting the exception:

    "Could not find installable ISAM"

     Can anyone tell me what could be wrong?

    Also I would like to add that I am able to connect to sql server with oledb. Problem is coming only with ms-access.

    If you want more info: I am using office 2007 and  OS is xp.  I also tried to change the version number in extended properties of connection string as suggested in some sites. But I am getting the same problem. Please someone explain me what this exception means and how to avoid it.

    Thanks in advance..

    Tuesday, October 21, 2008 5:04 AM

Answers

  • User-821857111 posted

    You usually get this error when your connection string has a parameter value that doesn't exist, eg ""
     

    9 times out of 10, it's caused by not leaving a space between "Data" and "Source":

    Provider=Mcrosoft.Jet.OLEDB.4.0;Data Source=mydb.mdb"

    ----------------------------------------------^

                                              Need space there

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 21, 2008 2:31 PM
  • User-1087343799 posted

     check this

    http://www.connectionstrings.com/?carrier=access2007 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 22, 2008 8:18 AM

All replies

  • User-1087343799 posted

    You usually get this error when your connection string has a parameter value that doesn't exist, eg "Provider=Mcrosoft.Jet.OLEDB.4.0.;huh=wrong;"

    If your connection string is ok, try with http://support.microsoft.com/kb/209805 

    Tuesday, October 21, 2008 5:46 AM
  • User-821857111 posted

    You usually get this error when your connection string has a parameter value that doesn't exist, eg ""
     

    9 times out of 10, it's caused by not leaving a space between "Data" and "Source":

    Provider=Mcrosoft.Jet.OLEDB.4.0;Data Source=mydb.mdb"

    ----------------------------------------------^

                                              Need space there

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 21, 2008 2:31 PM
  • User-132834496 posted

    Yes..yes.. got it..

    I did that silly mistake. Thanks for pointing it out.

     But I have another problem.. If I am connecting to earlier version files of access which have extension .mdb, it's working fine. But for the new versions which have the extension .accdb, I am getting the exception "Unrecognized database format "c:\database1.accdb"

    It seems this version is not supported. Then, how should I connect to such files with oledb?

     

    Wednesday, October 22, 2008 7:16 AM
  • User-1087343799 posted

     check this

    http://www.connectionstrings.com/?carrier=access2007 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 22, 2008 8:18 AM
  • User-132834496 posted

    Thanks a lot.. This solved my problem. Everything's working fine now.

    Thanks once again..

    Wednesday, October 22, 2008 8:33 AM