Answered by:
Error: "Could not find installable ISAM."

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...
Thanks.
Monday, October 11, 2010 4:54 PM