How do I Connect TO MS Access Database using OLEDb.NET/ADO.NET?

  • Thread starter Thread starter SortaNorth
  • Start date Start date
S

SortaNorth

I am unable to connect to my MS Access Database, using the standard
connection string in OLEdb.net: (VB.NET)
"Provider=Microsoft.Jet.Oledb.4.0;Data Source = \somepath\mydb.mdb;"

This string causes an error to be thrown: "Could not find Installable ISAM."

Someone suggested this was because you must install both the jet4 oledb
drivers and the jet engine runtime on the web server, and that is not
normally done as part of the original installation, since MS wants to
discourage the use of MS Access with ADO.NET.

How do I determine which version of the MDAC to install to get this
combination to work. All the MDAC versions since 2.6+ say they do not
include the Microsoft Jet, Microsoft Jet OLE DB Provider, or the Desktop
Database Drivers ODBC Driver. However, the earlier version only include the
pre .NET versions, so they may not work either.

Help?

Thanks for any assistance.
 
¤ I am unable to connect to my MS Access Database, using the standard
¤ connection string in OLEdb.net: (VB.NET)
¤ "Provider=Microsoft.Jet.Oledb.4.0;Data Source = \somepath\mydb.mdb;"
¤
¤ This string causes an error to be thrown: "Could not find Installable ISAM."
¤
¤ Someone suggested this was because you must install both the jet4 oledb
¤ drivers and the jet engine runtime on the web server, and that is not
¤ normally done as part of the original installation, since MS wants to
¤ discourage the use of MS Access with ADO.NET.
¤
¤ How do I determine which version of the MDAC to install to get this
¤ combination to work. All the MDAC versions since 2.6+ say they do not
¤ include the Microsoft Jet, Microsoft Jet OLE DB Provider, or the Desktop
¤ Database Drivers ODBC Driver. However, the earlier version only include the
¤ pre .NET versions, so they may not work either.
¤

Jet is a separate download:

http://support.microsoft.com/?kbid=829558


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top