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

Posted on 2006-05-08
Last Modified: 2007-11-27
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

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)

        Dim CSVDataSet As DataSet = New DataSet()
        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
Question by:bruintje
    LVL 28

    Accepted Solution


    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

    LVL 44

    Author Comment

    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
    LVL 44

    Author Comment

    found the correct string finally here

    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

    Featured Post

    Training Course: Java/J2EE and SOA

    This course will cover both core and advanced Java concepts like Database connectivity, Threads, Exception Handling, Collections, JSP, Servlets, XMLHandling, and more. You'll also learn various Java frameworks like Hibernate and Spring.

    Join & Write a Comment

    Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
    Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now