Hi

I have been successfully using ADO for a long time but now I am getting 

this error: -



ADODB.Connection error '800a0e7a'



Provider cannot be found. It may not be properly installed.



/sites/cullenauctioneers/Cullen Site/index1.asp, line 20



objConn.Open strConnect



 It's not just happening with this site, it won't work with any of the 

sites that were working previously.



The only thing which I did lately was to install Office 2000 on my PC 

yesterday but my ADO connections were working since then



A strange file which I found which must be related to the installation 

of Office 2000 is called MDACSET.log and had the following wording in it 

: -



Let's get out of here

2.1 already installed



I have re run Mdac_typ.exe and it hasn't made any difference either



Can anybody please help me??????





 Kind Regards

Oliver Dempsey

Perhaps try installing the latest MDAC (2.6).  I think it's available

here:

http://www.microsoft.com/Data/download.htm





> -----Original Message-----

> From: Oliver Dempsey [mailto:odempsey@b...]

> Sent: Friday, June 15, 2001 3:50 PM

> To: ASP Databases

> Subject: [asp_databases] ADODB.Connection error '800a0e7a'

>

>

> Hi

> I have been successfully using ADO for a long time but now I

> am getting =3D

> this error: -

> =3D20

> ADODB.Connection error '800a0e7a'=3D20

>

> Provider cannot be found. It may not be properly installed.=3D20

>

> /sites/cullenauctioneers/Cullen Site/index1.asp, line 20=3D20

>

> objConn.Open strConnect

>

>  It's not just happening with this site, it won't work with

> any of the =3D

> sites that were working previously.

>

> The only thing which I did lately was to install Office 2000

> on my PC =3D

> yesterday but my ADO connections were working since then

>

> A strange file which I found which must be related to the

> installation =3D

> of Office 2000 is called MDACSET.log and had the following

> wording in it =3D

> : -

>

> Let's get out of here

> 2.1 already installed

>

> I have re run Mdac_typ.exe and it hasn't made any difference either

>

> Can anybody please help me??????

>

>

>  Kind Regards

> Oliver Dempsey

>

I have installed MDAC 2.6 and reinstalled PWS I am still getting

ADODB.Connection error '800a0e7a'.

  Even when viewing htm documents through PWS it is slower now, on my

machine than it would take on the internet.



Can anybody tell me what's wrong?????????





Regards

Oliver Dempsey







----- Original Message -----

From: "Peter Foti (PeterF)" <PeterF@S...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, June 15, 2001 10:05 PM

Subject: [asp_databases] RE: ADODB.Connection error '800a0e7a'





Perhaps try installing the latest MDAC (2.6).  I think it's available

here:

http://www.microsoft.com/Data/download.htm





> -----Original Message-----

> From: Oliver Dempsey [mailto:odempsey@b...]

> Sent: Friday, June 15, 2001 3:50 PM

> To: ASP Databases

> Subject: [asp_databases] ADODB.Connection error '800a0e7a'

>

>

> Hi

> I have been successfully using ADO for a long time but now I

> am getting 

> this error: -

> 

> ADODB.Connection error '800a0e7a'

>

> Provider cannot be found. It may not be properly installed.

>

> /sites/cullenauctioneers/Cullen Site/index1.asp, line 20

>

> objConn.Open strConnect

>

>  It's not just happening with this site, it won't work with

> any of the 

> sites that were working previously.

>

> The only thing which I did lately was to install Office 2000

> on my PC 

> yesterday but my ADO connections were working since then

>

> A strange file which I found which must be related to the

> installation 

> of Office 2000 is called MDACSET.log and had the following

> wording in it 

> : -

>

> Let's get out of here

> 2.1 already installed

>

> I have re run Mdac_typ.exe and it hasn't made any difference either

>

> Can anybody please help me??????

>

>

>  Kind Regards

> Oliver Dempsey

>

From the Microsoft web site:

http://support.microsoft.com/support/kb/articles/Q191/2/71.ASP?LN=3DEN-U

S&

SD=3Dgn&FR=3D0&qry=3D800a0e7a&rnk=3D1&src=3DDHCS_MSPSS_gn_SRCH&SPR=3DMSA

LL

CAUSE

The MSDASQL OLE DB provider is either unavailable or is not registered.

This can be caused by an incomplete upgrade or a bad install of the

Microsoft Data Access Components (MDAC) components.







RESOLUTION

Here are two ways to resolve this problem:



Register the Msdasql.dll using the following command:

REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"







Reinstall the Microsoft Data Access Components used. The newest version

of MDAC can be downloaded from the following Web site:

http://www.microsoft.com/data/download.htm













STATUS

This behavior is by design.







> -----Original Message-----

> From: Oliver Dempsey [mailto:odempsey@b...]

> Sent: Saturday, June 16, 2001 3:31 PM

> To: ASP Databases

> Subject: [asp_databases] RE: ADODB.Connection error '800a0e7a'

>

>

> I have installed MDAC 2.6 and reinstalled PWS I am still getting

> ADODB.Connection error '800a0e7a'.

>   Even when viewing htm documents through PWS it is slower now, on my

> machine than it would take on the internet.

>

> Can anybody tell me what's wrong?????????

>

>

> Regards

> Oliver Dempsey

>

Hi

I've done all that stuff but with no success.  I understand that it is not

easy to uninstall MDAC either.



I can connect to the datastore if I set up a DSN but it continues to throw

up the ADODB.Connection error '800a0e7a' when I try to connect using

server.mappath



It's definitely not an error in my code because I have about 30 sites that

were working previously but not now.

----- Original Message -----

From: "Peter Foti (PeterF)" <PeterF@S...>

To: "ASP Databases" <asp_databases@p...>

Sent: Monday, June 18, 2001 2:57 PM

Subject: [asp_databases] RE: ADODB.Connection error '800a0e7a'





From the Microsoft web site:

http://support.microsoft.com/support/kb/articles/Q191/2/71.ASP?LN=EN-US&

SD=gn&FR=0&qry=800a0e7a&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=MSALL

CAUSE

The MSDASQL OLE DB provider is either unavailable or is not registered.

This can be caused by an incomplete upgrade or a bad install of the

Microsoft Data Access Components (MDAC) components.







RESOLUTION

Here are two ways to resolve this problem:



Register the Msdasql.dll using the following command:

REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"







Reinstall the Microsoft Data Access Components used. The newest version

of MDAC can be downloaded from the following Web site:

http://www.microsoft.com/data/download.htm













STATUS

This behavior is by design.







> -----Original Message-----

> From: Oliver Dempsey [mailto:odempsey@b...]

> Sent: Saturday, June 16, 2001 3:31 PM

> To: ASP Databases

> Subject: [asp_databases] RE: ADODB.Connection error '800a0e7a'

>

>

> I have installed MDAC 2.6 and reinstalled PWS I am still getting

> ADODB.Connection error '800a0e7a'.

>   Even when viewing htm documents through PWS it is slower now, on my

> machine than it would take on the internet.

>

> Can anybody tell me what's wrong?????????

>

>

> Regards

> Oliver Dempsey

>

Oliver,



The error means that the server could not find the relevant Provider. This

may be caused by a number of reasons:

a) The provider is not installed. For example, you mentioned that you

installed MDAC v2.6 - however MDAC v2.6 does not include Jet OLEDB

Providers, or Access ODBC drivers. You need to download and install them

separately, as per the readme on the Microsoft website. So if you are using

Access, this might be a possible cause

b) The connection string is malformed, and so the server doesn't know what

to connect to.

I suggest you do this



strConnect = _

    "Provider=Microsoft.Jet.OLEDB.4.0;" & _

    "Data Source=" & Server.Mappath("databasename.mdb") & ";"



Response.Write(strConnect)



and make sure that strConnect contains what it's supposed to!



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Oliver Dempsey" <odempsey@b...>

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, June 19, 2001 2:27 AM

Subject: [asp_databases] RE: ADODB.Connection error '800a0e7a'





: Hi

: I've done all that stuff but with no success.  I understand that it is not

: easy to uninstall MDAC either.

:

: I can connect to the datastore if I set up a DSN but it continues to throw

: up the ADODB.Connection error '800a0e7a' when I try to connect using

: server.mappath

:

: It's definitely not an error in my code because I have about 30 sites that

: were working previously but not now.