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?
Sorry, this blog does not support comments. Why not?
I used various blog hosting services since this blog was established in 2005, but unfortunately they turned out to be unreliable in the long term and comment threads were lost in unavoidable transitions. At this time I don't want to enable third-party services for comments since it has become obvious in recent years that these providers invariably monetize information about their visitors and users.
Please use the links in the page footer to get in touch with me. I'm available for conversations on Keybase, Matrix, Mastodon or Twitter, as well as via email.