By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

"Could not find installable ISAM"

P: n/a
I am trying to connect to an Access 2000 database from VB.NET and I
get this error "Could not find installable ISAM." I don't think there
is anything wrong with my connection string.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\Levine\Desktop\ROWriter.mdb;User ID=Admin;Password=;"

Any suggestions? Do I have to change the registry? or reinstall VS?

Thank You
Oran

May 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
First thing to try is create a UDL file an use that to connect to the db.
If you can connect in this way then there is something wrong with your code.

The added advantage of sing a UDL file is that you can use it as the
connection string for an ADO connection (not sure about ADO.NET on this one
though).

In ADO you would assign the connection string as follows

With loCon
.ConnectionString = "File Name=c:\myudl.udl"
.Open
End with

After you open the connection you can inspect the connectionstring property
as this is expanded from the udl file, you can then use that as the basis of
you connectionstring in your application.

A simple function to do this coul be
Function UDLFileConnect(UDLFileName As String) As String
Dim loCon As ADODB.Connection

Set loCon = New ADODB.Connection
With loCon
.ConnectionString = "File Name=" & UDLFileName
.Open
UDLFileConnect = .ConnectionString
.Close
End With
Set loCon = Nothing
End Function

When I call this from the debug window with
?UDLFileConnect("C:\ng_test.udl")
I get
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=C:\wzForms.mda;Mode=Share Deny None;Extended Properties="";Jet
OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database
Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet
OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False
--

Terry Kreft
<or*****@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
I am trying to connect to an Access 2000 database from VB.NET and I
get this error "Could not find installable ISAM." I don't think there
is anything wrong with my connection string.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\Levine\Desktop\ROWriter.mdb;User ID=Admin;Password=;"

Any suggestions? Do I have to change the registry? or reinstall VS?

Thank You
Oran

May 27 '06 #2

P: n/a
Thank you for your idea! I had the wrong connection string.
Oran

May 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.