• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 827
  • Last Modified:

How to circumvent the message "could not find installable ISAM"

Hello All,

Been looking at this since friday and accepted it for a fact but would like to solve my problem.

I have a small project that reads a csv file like

---------
field1;field2;field3;field4;
myname here;anothername ;and anotherone;the last one;
myname here;anothername ;and anotherone;the last one;
myname here;anothername ;and anotherone;the last one;
myname here;anothername ;and anotherone;the last one;
---------

and some code that reads the CSV into a Dataset like

---------
    Private Function GetCSVFile(ByVal pathName As String, ByVal fileName As String) As DataSet
        Dim CSVConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & pathName & ";Extended Properties=Text;")
        Dim CSVCommand As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM " & fileName, CSVConnection)
        Dim CSVAdapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(CSVCommand)

        CSVConnection.Open()
        Dim CSVDataSet As DataSet = New DataSet()
        CSVAdapter.Fill(CSVDataSet)
        CSVConnection.Close()
        Return CSVDataSet
    End Function
---------

That works except when you need to add some more extended properties like HDR=YES; etc.... I know i'm missing something but what?

Whatever i try, like quotes or double quotes or same line or anything else it does not work, so i leave this question open until someone posts a working piece of code in VB or C# doesn't matter as long as it works for loading a textfile into a dataset and being able to add more extended properties then Extended Properties=Text;

thanks a bunch
Brian
0
bruintje
Asked:
bruintje
  • 2
1 Solution
 
iboutchkineCommented:
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

registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\...
0
 
bruintjeAuthor Commented:
thanks for that note, i found the file and in the registry on the same path so following up
i need to be at home to put in the disc doing the install / repair of office
0
 
bruintjeAuthor Commented:
found the correct string finally here
source: http://www.thescripts.com/forum/thread387079.html

so my string becomes
Dim CSVConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & pathName & ";Extended Properties=""Text;HDR=Yes;FMT=Delimited""")

which works

thanks for your interest
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now