|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
ole DB connection help!!!!
hello, i am new to all this database connection stuff. i am doing a tutorial on MS IIS and after following ever step to the letter I still get this error message.
Error Type: ADODB.Connection (0x800A0E7A) Provider cannot be found. It may not be properly installed. /asptestsite/mytestsite/database.asp, line 39 this is the part of the script where i think im getting the message. (around line 39) : strDBVirtualPath = "/iishelp/iis/htm/tutorial/EECustmr.mdb" strDBLocation = Server.Mappath(strDBVirtualPath) strSource = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strDBLocation Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.Open strSource SQLQuery = "SELECT * FROM Customers" Set rsCustomersList = objConnection.Execute(SQLQuery) I also attached the full script . |
|
#2
|
||||
|
||||
|
Based on your error message, I'm guessing that your machine does not have an Access version 3.51 OLEDB provider.
Here's some things you might want to do: 1. Go to your ODBC Administrator (on my machine it is Start->Settings->Control Panel->Administrative Tools->Data Sources (ODBC). Go to the Drivers tab and see what version of a driver you have for .mdb files. Make your code match that version and see if your code runs. See the attached screenshot. 2. Download the MDAC Component Checker and see what provider you have loaded on your machine. http://www.microsoft.com/downloads/...&displaylang=en 3. Download MDAC 2.5 or earlier. I believe they stopped putting the Jet provider in the MDACs starting with version 2.6. http://www.microsoft.com/downloads/...&DisplayLang=en If all this fails, let us know and maybe someone else can come up with a bright idea. |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > ole DB connection help!!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|