Further to my email regarding the following error:



ADODB.Connection error '800a0e7a'



ADO could not find the specified provider.



I have tried what Andy suggested but it did not work. Please find the

message below. 



Do you think that when the SQL and IIS servers where set up "sqloledb"

driver was not installed?? If so, how can I correct this problem. 



IF I connect to the database using ODBC, it works fine. But I would like to

bypass some layer and connect using the following string:





strconn = "Provider=sqloledb;User ID=sa;Password=mark;Initial

Catalog=Claudio;Data Source=EEHAII003099"



Looking forward to your reply.



Cheers,



Claudio



-------------------------------------------------

Hi Claudio,



the name of your db-driver is "sqloledb" or is it "SQL Server"?

you find it in your odbc-database-administration tool.

If the name of the driver is "SQL Server", then try this



strconn = "Provider={SQL Server};User ID=sa;Password=mark;Initial

Catalog=Claudio;Data Source=EEHAII003099"



I had the same problem as used "sqloledb", when i tried it with the name of

db-driver

"SQL Server" and it works!





Andy







Subject: SQL ODBC

From: "Pallone, Claudio [KMR-SPC]" <Claudio.Pallone@k...>

Date: Fri, 20 Apr 2001 09:51:44 +0100

X-Message-Number: 1



Hello ASP Programmers,



I am using the string below to connect to the SQL server from my

workstation:



strconn = "Provider=sqloledb;User ID=sa;Password=mark;Initial

Catalog=Claudio;Data Source=EEHAII003099"



But get the following error message:



ADODB.Connection error '800a0e7a'



ADO could not find the specified provider.



/sql.asp, line 9



I have checked the SQL server and the SQL driver is installed properly since

I can access the database using ODBC. Could you please help me to find a

solution for this problem?



Cheers,



Claudio