ASP Connection Error

[larryman]

Hi all,

Please i have a problem connecting to my Access database on my webserver(IIS). I was formerly running PWS but decided to move to IIS so that i could use CDONTS. Whenever i try to connect to the database on (IIS) i get this error:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.

I have downloaded MDAC 2.5 from microsoft site and after installation, i still get the error.

Looking forward to any help.

 

[codestorm]

What's the connection string look like? codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[larryman]

Thanks Codestorm,
I finally fixed it. but the code looks like this

Set dcnDB = Server.CreateObject(&quot;ADODB.Connection&quot
dcnDb.ConnectionString = _
& &quot;Provider=Microsoft.Jet.OLEDB.3.51:&quot;
& &quot;Data Source=Mydatasource&quot;
dcnDB.Open

I found out that the version i specified was not on the server so i changed it to version 4.0 which the server has and it has since started working fine.

Thanks.
Larryman Oysterbar ride to success. Keep Riding