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.
No comments:
Post a Comment