Cannot find installable ISAM..."

E

EpcH

New member
Joined
Jul 17, 2003
Messages
2
Location
USA
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 ?
 
it gives that message when the connection string isnt correct ( especially if using a password )
heres a quick example ( without password in connection string )
Code: 
    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 :
Code: 
    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 , its not that drastic )
 
Back
Top