Could not find installable ISAM.
-
Hello folks, I continue to struggle with making the connection to my access 2002 database with asp.net. I think I have the connection string /provider stuff figured out, but when I try it from my server I get Could not find installable ISAM. my website host www.general-hosting.com claims to support ODBC connectivity and access, but I get this ISAM error. here is the code... connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " connectionString &= "DNS=webdata; DRIVER={Microsoft Access Driver (*.mdb)};" 'connectionString &= "Data source=amzg12122.general-hosting.com/fpdb/mywebdb.mdb;" connectionString &= "DBQ=URL=amzg12122.general-hosting.com/fpdb/mywebdb.mdb;" 'connectionString &= "Catalog=mywebdb.mdb;" Me.myWebDbconn = New OleDbConnection() Me.myWebDbconn.ConnectionString = connectionString Response.Write(connectionString) Me.myWebDbconn.Open() ' ************* Error ******************* The server generates the following error message... Server Error in '/' Application. -------------------------------------------------------------------------------- Could not find installable ISAM. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OleDbException (0x80004005): Could not find installable ISAM.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20 System.Data.OleDb.OleDbConnection.InitializeProvider() +57 System.Data.OleDb.OleDbConnection.Open() +131 amzg12122.general_hosting.com.WebForm1.MakeODBCConnection() in C:\Documents and Settings\Robert Peterson\VSWebCache\amzg12122.general-hosting.com\loginform.aspx.vb:54 amzg12122.general_hosting.com.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\Robert Peterson\VSWebCache\amzg12122.general-hosting.com\loginform.aspx.vb:34 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +29 System.Web.UI.Page.ProcessRequestMain() +724 What I find curious, (and I really don't understand) is that e