|
 |
access_asp thread: "provider not found" error
Message #1 by gchen@t... on Mon, 22 Oct 2001 18:20:18
|
|
Hi,
I am getting the follow message:
"ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed."
And here's the ASP code responsible for the error:
-------------------------
Dim adoCon
Dim adoRec
Dim SQL
SQL = "Select A.AdvertName, A.AdmarcID, B.HomeDeliveryInd,
B.SplitBillingInd, B.SubZipInd From Advertiser A, AdvertiserInd B Where
A.AdmarcID = B.AdmarcID Order by A.AdvertName"
Set adoCon = Server.CreateObject("ADODB.Connection")
Set adoRec = Server.CreateObject("ADODB.Recordset")
AdoCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data
Source=\\ctc-sql-lv\updates\Referenc.mdb"
AdoCon.Open
AdoRec.ActiveConnection = AdoCon
AdoRec.Open SQL, AdoCon, adOpenStatic
------------------------------
The error seems to be coming from the line "AdoCon.Open". FYI, I have
installed MDAC 2.6 SP1 on the web server (running W2K/IIS5) but the
problem persists.
Thanks in advance for any advice and help!
George
Message #2 by "Frank Kech" <fkech@s...> on Mon, 22 Oct 2001 13:41:21 -0500
|
|
Try running the database local. If that solves the problem, set the web app
security to basic. Probably an authentication problem.
-----Original Message-----
From: gchen@t... [mailto:gchen@t...]
Sent: Monday, October 22, 2001 6:20 PM
To: Access ASP
Subject: [access_asp] "provider not found" error
Hi,
I am getting the follow message:
"ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed."
And here's the ASP code responsible for the error:
-------------------------
Dim adoCon
Dim adoRec
Dim SQL
SQL = "Select A.AdvertName, A.AdmarcID, B.HomeDeliveryInd,
B.SplitBillingInd, B.SubZipInd From Advertiser A, AdvertiserInd B Where
A.AdmarcID = B.AdmarcID Order by A.AdvertName"
Set adoCon = Server.CreateObject("ADODB.Connection")
Set adoRec = Server.CreateObject("ADODB.Recordset")
AdoCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data
Source=\\ctc-sql-lv\updates\Referenc.mdb"
AdoCon.Open
AdoRec.ActiveConnection = AdoCon
AdoRec.Open SQL, AdoCon, adOpenStatic
------------------------------
The error seems to be coming from the line "AdoCon.Open". FYI, I have
installed MDAC 2.6 SP1 on the web server (running W2K/IIS5) but the
problem persists.
Thanks in advance for any advice and help!
George
Message #3 by opli@k... on Tue, 23 Oct 2001 06:23:29
|
|
Hi,
if you are running web server on Windows 2000 and IIS5,
you will check your jet driver version.
AdoCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data
> Source=\\ctc-sql-lv\updates\Referenc.mdb"
Windows2000 and iis5 are using version 4 of OLEDB,
so your code changed below..
Provider=Microsoft.Jet.OLEDB.4.0;
and sorry my poor english..
happy coding...
- opli
|
|
|
View Cart
