[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ISAM ?

Posted on 2006-04-22
2
Medium Priority
?
609 Views
Last Modified: 2009-07-29
I get this run-time error message "Could not find installable ISAM" when I ran the following codes to connect to my sample database. Please help. I have Office 2000 and Windows Xp pro.





Dim myConnection As OleDbConnection

    Dim myCommand As OleDbCommand

...



Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click


        myConnection = New OleDbConnection("provider = microsoft.jet.oledb.4.0; datasource = C:\Documents and Settings\Test\Desktop\Cardatabase.mdb")


        myCommand = New OleDbCommand(" insert into CarTable(Year, Make, Model, Type) values ('" & Me.txtYear.Text & "' , " & " ' " & Me.txtMake.Text & " ' , '" & Me.txtModel.Text & " ' " & Me.txtType.Text & " ') ", myConnection)



        Try

            myConnection.Open()
            myCommand.ExecuteNonQuery()
            MsgBox("ok")


        Catch ex As OleDb.OleDbException

            MsgBox(ex.ToString)
            myConnection.Close()


        End Try


    End Sub
0
Comment
Question by:VBdotnet2005
2 Comments
 
LVL 14

Expert Comment

by:PockyMaster
ID: 16518186
0
 
LVL 28

Accepted Solution

by:
iboutchkine earned 2000 total points
ID: 16524464
http://support.microsoft.com/support/kb/articles/Q155/6/66.asp
http://support.microsoft.com/?id=209805

The DLL for an installable ISAM file could not be found. This file is required for linking external tables
(other than ODBC or Microsoft Jet database tables). The locations for all ISAM drivers are maintained in the
Windows Registry. These entries are created automatically when you install your application. If you change
the location of these drivers, you need to correct your application Setup program to reflect this change and
make the correct entries in the Registry.

Possible causes:

An entry in the Registry is not valid. For example, this error occurs if you're using a Paradox external
database and the Paradox entry points to a nonexistent directory or driver. Exit the application, correct the
Windows Registry, and try the operation again.


One of the entries in the Registry points to a network drive and that network is not connected. Make sure
the network is available, and then try the operation again.

--------------------------------------------------------
Another cause
The error occures when you are using a different version ACCESS than the original code did so the
"connect" property of the data-control is set wrong. Just set it ot the correct one

If you want to see other DB drivers, while installing Access check under Access- Database Drivers

registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Loops Section Overview
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question