ADODB.Connection error '800a0e7a' in sql server 2005

i've developed one small application in asp with some vbscript and some javascript.

i connect to the database by:

Set DB = Server.CreateObject("ADODB.Connection")
DB.Open "Provider=sqloledb;Data Source=(local);Initial Catalog=HelpDesk;User Id=AAAAA;Password=********;"

all were going well (local sql server 2000) but... when i've moved the application to the application server with sql server 2005 i get the following error when i try to acced throw ie explorrer:

i have insttaled the latest mdac (2.8) and register the msdasql.dll

ADODB.Connection error '800a0e7a'

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

Help pls.

NS.

Please try to register sqloledb.dll, because you are using sqloledb provider.

Hope, it helps.

ADODB.Connection error '800a0e7a' in sql server 2005

i've developed one small application in asp with some vbscript and some javascript.

i connect to the database by:

Set DB = Server.CreateObject("ADODB.Connection")
DB.Open "Provider=sqloledb;Data Source=(local);Initial Catalog=HelpDesk;User Id=AAAAA;Password=********;"

all were going well (local sql server 2000) but... when i've moved the application to the application server with sql server 2005 i get the following error when i try to acced throw ie explorrer:

i have insttaled the latest mdac (2.8) and register the msdasql.dll

ADODB.Connection error '800a0e7a'

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

Help pls.

NS.

Please try to register sqloledb.dll, because you are using sqloledb provider.

Hope, it helps.

ADODB.Connection error 800a0e7a

I am getting the following error, when I try to run my ASP Web pages on an NT4 server has anyone got any Ideas ?

ADODB.Connection error '800a0e7a'

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

I have installed every service pack and rebooted even reregistering .dlls

Anyone got any Ideas ?If your problem is like mine, you are getting this error because your MDAC got hosed.
I was un-installing something seemingly harmless and before I knew it I saw a flurry of mdac dlls being deleted.
After that, SQLServer7's Enterprise Manager and other VB6 database apps started failing with this error.
I re-installed the MDAC (26) and it (thankfully) fixed the problem.
Hope this helps.|||I agree - reinstall your mdac. You can try to reregister the individual dll that is causing the problem - but that may only be a partial fix.