Cannot find installable ISAM..."

[EpcH]

Hi All,

 

I installed VS.NET a day ago and having some trouble now with the error "Cannot find installable ISAM..."

 

What I did is :

 

I added an Oledbconnection Connection to my form, configured it for Access 2000, test the connection and it was ok.

 

And then I tried to add an OleDbAdapter, a wizard poped up, it was fine :) , I selected my DbConnection and then defined my query. When I pressed Finish Button in the wizard, a Login box pop ups and asks me For Login name and password?

 

What do I suppose to enter these fields? My db is not password protected, my connection works fine ( I mean I tested it while creating DbConnection and also I can build queryies with the db adapter wizard ), but it keeps poping up that Login box.

 

I am using win2k professional, so I tried to use my predefined userIDs and passwords for my win2k, when I do so, it says "Cannot start your application, The workgroup information file is missing or opened exclusively by another user".

 

When I try only entering the Login name as "Admin" ( which is default while creating DbConnection ) and an empty Password, it says "Cannot find installable ISAM..."

 

I searched MSDN for an answer but the only article I found about this error is talking about using foxpro with older mdac versions ( version lower than 2.1 ) , and I am using mdac 2.7.

 

I know that there is a small thing I am missing, or lets say I hope that..

 

Do you have any idea ?

[jspencer]

Try reinstalling Access on your machine. Select all of the installable components as well. See if that helps things.

[dynamic_sysop]

it gives that message when the connection string isn't correct ( especially if using a password )

here's a quick example ( without password in connection string )

   Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
       Dim constring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDb.mdb"
       Dim objDbConnection As New OleDbConnection(constring)
       Try
           objDbConnection.Open()

           Dim objCommand As New OleDbCommand("SELECT * FROM Table1", objDbConnection)
           Dim objAdaptor As OleDbDataAdapter = New OleDbDataAdapter(objCommand)
           Dim objDataSet As New DataSet()
           objAdaptor.Fill(objDataSet, "Table1")

           DataGrid1.DataSource = objDataSet.Tables("Table1")
       Catch ex As Exception
           MessageBox.Show(ex.Message)
       Finally
           objDbConnection.Close()
       End Try
   End Sub

 

if you choose to use a pwd protected database you can do this :

   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
       Dim strPath As String = Application.StartupPath & "\db4.mdb"
       Dim strPass As String = "sysop" '/// the password for your db goes here.

       Dim Connection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & ";Jet OLEDB:Database Password=" & strPass & ";User ID=Admin;Persist Security Info=True"
       Dim Command As String = "SELECT * FROM Table1"
       OpenAccessFile(Connection, Command)

   End Sub

   Private Sub OpenAccessFile(ByVal strConnection As String, ByVal strCommand As String)
       Try
           Dim objDbConnection As New OleDbConnection(strConnection)

           objDbConnection.Open() '///open a new connection.

           Dim objCommand As New OleDbCommand(strCommand, objDbConnection)
           Dim objAdaptor As OleDbDataAdapter
           objAdaptor = New OleDbDataAdapter(objCommand)
           Dim objDataSet As New DataSet()
           objAdaptor.Fill(objDataSet, "Table1")
           DataGrid1.DataSource = objDataSet.Tables("Table1") '///fill a datagrid with the recordset

           objDbConnection.Close()
           objCommand.Dispose()
           objAdaptor.Dispose()
           objDataSet.Dispose()
       Catch ex As Exception
           MessageBox.Show(ex.Message)
       End Try
   End Sub

hope it helps ( but dont go un-installing access , it's not that drastic )