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?
