CODEWITHSUNDEEP
vb.netms-access-2007
Kobe Bryan
Kobe Bryan

Reputation: 317

"Could not find installable ISAM" error in VB.NET

Im new to visual basic.. I would like to ask on how to fixed the problem "Could not find installable ISAM.". I used Visual Basic as programming language. I used MS access as the database. My program is to fetch data from access. This would be my code.

Imports System.Data.OleDb

Module Main
Dim mDataPath As String

Sub Main()
    GetPupils()
    Console.ReadLine()

End Sub
Private Function GetConnection() As OleDb.OleDbConnection
    'return a new connection to the database5

    Return New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
     & "Database Password=oNer00FooR3n0 " & "Data Source=" & "C:\Users\ERICO YAN\Desktop\MSaccessDB\MSaccessDB\oneroofccp.mdb")
End Function


Public Function GetPupils() As DataSet
    Dim conn As OleDb.OleDbConnection = GetConnection()
    Try
        Dim ds As New DataSet  'temporary storage
        Dim sql As String = "select * from SESSIONS" 'query
        Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, conn) 'connection

        Try
            da.Fill(ds, "SESSIONS") 'fetch data from db
        Finally
            da.Dispose()    'in case something goes wrong
        End Try

        Dim startVal = 0 'first record
        Dim endVal = ds.Tables(0).Rows.Count 'total number records

        For var = startVal To endVal - 1 'display records
            Console.WriteLine(ds.Tables(0).Rows(var).Item(0).ToString() + " " + ds.Tables(0).Rows(var).Item(1).ToString() + " " + ds.Tables(0).Rows(var).Item(3).ToString() + " " + ds.Tables(0).Rows(var).Item(3).ToString())  'code for display id and name
        Next


        Return ds

    Finally
        conn.Close()
        conn.Dispose()
    End Try

End Function
End Module

I would like to know what is the cause of the error so that I can proceed to my program.. Thank you so much for the feedback..

Upvotes: 1

Views: 20787

Answers (3)

Mukesh L
Mukesh L

Reputation: 1

Initially, i too got this sort of error, but when i wrote the connection string in a single line (i mean without using [& _] or breaking in 2 lines, then this worked properly.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\USER1\Desktop\MSaccessDB\MSaccessDB\my_database_file.mdb;Database Password=MyPassword"

Hope this helps.

Mukesh L.

Upvotes: 0

Edwin de Koning
Edwin de Koning

Reputation: 14387

You seem to be missing a delimiter after your password attribute.

I think you also need to use Jet OLEDB:Database Password=... instead (if indeed you have an access database protected with a password):

"Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & "C:\Users\ERICO YAN\Desktop\MSaccessDB\MSaccessDB\oneroofccp.mdb;" _
& "Jet OLEDB:Database Password=oNer00FooR3n0;"

Upvotes: 1

Alex K.
Alex K.

Reputation: 175766

Missing ; delimiter here:

...Password=oNer00FooR3n0 " & "Data Sourc...

Needs to be

...Password=oNer00FooR3n0 " & ";Data Sourc...

Also just Password instead of Database Password.

Upvotes: 0

Related Questions