I am using Windows Server 2003, 64bit and I am trying to connect to a Access DB in Visual Studio (VB) and I get the error: (It can't find the Jet 4.0)
Provider cannot be found. It may not be properly installed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServ
ices.COMEx
ception: Provider cannot be found. It may not be properly installed.
Line 88: rs.Open("SELECT * FROM [Members]", "Provider=Microsoft.Jet.OL
EDB.4.0;Da
ta Source=" & Server.MapPath("App_Data/o
ldMemberdb
.mdb"), 3, 1)
Obviously the provider is not installed. I went on Microsoft's webpage and I downloaded "WindowsServer2003-KB82955
8-ia64-ENU
.exe" which is suppose to install the Jet pack. I run the file and it says "! The image file "..\update\update.exe" is valid, but is for a machine type other than the current machine" I am guessing that I have the incorrect version of the Jet Pack.
I have read other solutions and the only one I found speaks about installing Visual Web Express and rigging it somehow. Certainly there is another way to do this?? I am under a deadline, so please help. Thanks!
Start Free Trial