locked
Error: "Could not find installable ISAM." RRS feed

  • Question

  • User793909578 posted

    I use the following Function to connect to my .mdb;

        Function GetCurrentMonthData(ByVal firstDate As DateTime, ByVal lastDate As DateTime) As DataSet
    
            Dim sConnectionString, sSQL As String
    
            'SQL Connection String
            sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=" & Server.MapPath("/CalendarDb/app_Data/CalendarDb.mdb") & ";User Id=admin;Password=;"
            'MsgBox(sConnectionString)
            sSQL = "select * from tblEvent WHERE eventDate >= firstDate AND eventDate < lastDate"
    
            Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString)
            Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn)
            Dim dr As System.Data.OleDb.OleDbDataReader
            conn.Open()
            Try
                dr = cmd.ExecuteReader()
            Catch
            End Try
    
            Return dsEvents
        End Function


    When I run the page I get this error;

    System.Data.OleDb.OleDbException was unhandled by user code
      ErrorCode=-2147467259
      Message="Could not find installable ISAM."
      Source="Microsoft JET Database Engine"
      StackTrace:
           at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
           at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
           at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
           at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
           at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
           at System.Data.OleDb.OleDbConnection.Open()
           at _Default.GetCurrentMonthData(DateTime firstDate, DateTime lastDate) in c:\inetpub\wwwroot\CalendarDb\Default.aspx.vb:line 53
           at _Default.FillHolidayDataset() in c:\inetpub\wwwroot\CalendarDb\Default.aspx.vb:line 19
           at _Default.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\CalendarDb\Default.aspx.vb:line 12
           at System.Web.UI.Control.OnLoad(EventArgs e)
           at System.Web.UI.Control.LoadRecursive()
           at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
      InnerException:


    I tried installing the MDAC 2.8 and Jet 4.0 Service Pack 8 for XP but got the message that the service packs are either part of the OS or that my system is already up to date.  Is the error caused by the code or by something in my system?

    Monday, October 11, 2010 4:36 PM

Answers

  • User-874886737 posted

    The error is caused by an incorrect connection string.

    "Data Source" should be written with a space.

    Jos 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 11, 2010 4:43 PM

All replies

  • User-874886737 posted

    The error is caused by an incorrect connection string.

    "Data Source" should be written with a space.

    Jos 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 11, 2010 4:43 PM
  • User793909578 posted

    Are you kidding me?  I need more coffee...  Foot in mouth


    Thanks.

    Monday, October 11, 2010 4:54 PM