Could not find installable ISAM… my a*$%

I had this test program that used a connection string to open a Jet format database. Worked just fine. I copied the connection string over to a more complex project, and all of a sudden I got an exception saying “Could not find installable ISAM”. Wow. Looking around, there’s lots of info about that message, some of it from Microsoft, like here and here. None of that seemed to have anything to do with my problem, though.

Know what it was? The connection string should have been this: Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;data source=blah.mdb;user id=Admin;password=;, but instead I had accidentally modified it to this: Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;datasource=blah.mdb;user id=Admin;password=;

Spot the difference? Yeah, right… Microsoft: how about an “Unknown parameter in connection string” exception, or at least a “Missing ‘data source’ parameter”. Could not find installable ISAM? WTF?

4 Comments on Could not find installable ISAM… my a*$%

  1. i just fu$&!ing fixed this error as well i forgot how horrid the error descriptions are sometimes for these products.

    Like

  2. Thanks a million!!!! Struggled for hours on this one

    Like

  3. I had this problem too. I found that the path I was using was OK for my workstation but not the server.. I had to use UNC address for the SQLserver to see the file.eg. servernamesharedfolderfolder2 instead of F:folder2HTHGreg

    Like

  4. I’m just learning this stuff, and I’d spent about 2 futile and frustrating hours trying various other "solutions" from Microsoft and others. Many thanks for the one that worked.

    Like

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s