March 18th, 2003, 03:40 PM
Join Date: Aug 2002
Time spent in forums: < 1 sec
Reputation Power: 17
"Could not find installable ISAM."
I've googled myself to death and no solutions seem to work. I'm having a hell of a time getting VS and .NET all set up and working on this computer. I had to jump through hoops to get ASP.NET to work. Now I can't seem to make the Data Access happen.
The weird thing is, using the same connection string, I can connect to the database and query it from a CONSOLE app, but I can't do it from a web application. Here is the code...
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Public Sub Load_Grid()
Dim myCxn As OleDbConnection
Dim myCmd As OleDbCommand
Dim strCxn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Pwd="""";User ID=Admin;" & _
myCxn = New OleDbConnection(strCxn)
myCmd = New OleDbCommand("SELECT * FROM Store")
myCmd.Connection = myCxn
myGrid.DataSource = myCmd.ExecuteReader(CommandBehavior.CloseConnectio n)
Catch ex As Exception
Response.Write("An exception occurred.<br>")
Response.Write(ex.Source & " : " & ex.Message)
If Not myCxn Is Nothing Then
If myCxn.State <> ConnectionState.Closed Then
myCxn = Nothing
myCmd = Nothing
When I run it, It prints out a Microsoft Jet Driver Error, "Could not find installable ISAM". I tried to re-register msjet40.dll, that didn't fix it. I isntalled the odbc_net.exe update, even though that shouldn't be related to a DSN-less problem. And again, the same connection works in a console app.
EDIT: i have all the correct namespaces imported in the file too, i just pasted the relevant code. It can't be a coding problem.