Could not find installable ISAM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There. Seriously stuck and need help! I am trying to access Access 2000 database using ASP.NET(VB) and I am getting a "Could not find installable ISAM" crap. There are quite a few resources dedicated to solving this problem but none work (spent 6 hours on google trying everything suggested). The code I am using is very simple but does not work because if the ISAM rubbish!!! If anybody came across this problem and managed to solve it, please, please get in touch ([email protected]). I reinstalled Office, reinstalled JET, reinstalled ODBC.NET and NOTHING!!!!!!!!!!!!!!!!!
The code I am using is below
**********************
Private Const DataPath As String = "database/DB.mdb

Public ReadOnly OleDbConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;UserID=Admin;Pwd="""";" & "DataSource=" & DataPat

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Loa
adrAdverts.AdvertisementFile = "adverts.xml
If IsPostBack The
adrAdverts.AdvertisementFile = "adverts.xml
End I
Connect(
End Su

Private Sub Connect(
Tr
Dim cnn As New OleDbConnection(OleDbConnectionString
cnn.Open(
If cnn.State.Open The
lblError.Text = ("Open"
Els
lblError.Text = ("failed to open"
End I

Catch ex As Exceptio
lblError.Text = ex.ToStrin
End Tr
End Su
 
Hi Phil,

Normaly you should not get any ISAM stuff with ADO.Net that comes mostly
with Doa.

Maybe you can try it with this changes.

Public OleDbConnectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=database/Db.mdb;"

(The ASP.Net user needs of course to have rights on that virtual database
directory.)

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
adrAdverts.AdvertisementFile = "adverts.xml"
If IsPostBack Then
adrAdverts.AdvertisementFile = "adverts.xml"
End If
Connect()
End Sub
Private Sub Connect()
Try
Dim cnn As New OleDbConnection(OleDbConnectionString)
cnn.Open()
If cnn.State.Open Then
lblError.Text = ("Open")
Else
lblError.Text = ("failed to open")
End If

Catch ex As Exception
lblError.Text = ex.ToString
End Try
End Sub
Click to expand...
I hope this helps?

Cor
 
¤ Hi There. Seriously stuck and need help! I am trying to access Access 2000 database using ASP.NET(VB) and I am getting a "Could not find installable ISAM" crap. There are quite a few resources dedicated to solving this problem but none work (spent 6 hours on google trying everything suggested). The code I am using is very simple but does not work because if the ISAM rubbish!!! If anybody came across this problem and managed to solve it, please, please get in touch ([email protected]). I reinstalled Office, reinstalled JET, reinstalled ODBC.NET and NOTHING!!!!!!!!!!!!!!!!!!
¤ The code I am using is below:
¤ ***********************
¤ Private Const DataPath As String = "database/DB.mdb"
¤
¤ Public ReadOnly OleDbConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;UserID=Admin;Pwd="""";" & "DataSource=" & DataPath
¤

Unless there is a configuration issue this error typically indicates that there is a syntax problem
with the connection string. One of the first things I noticed in your example is that DataSource
should be two words and not one. Start out simple and then add arguments as necessary:

ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db10.mdb;" & _
"Jet OLEDB:Engine Type=5;")


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