Link to home
Start Free TrialLog in
Avatar of michaeldean99
michaeldean99Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

I have a problem with this bit of code

-------------------------------------------------------------------------
SET conn = Server.CreateObject("ADODB.Connection")
conn.open Application("dbConnect"),Application("dbUSER"),Application("dbPW")  ******

'* Transaction START
DIM connCart
SET connCart = Server.CreateObject("ADODB.Connection")
connCart.open conn
IF connCart.Properties("Transaction DDL") = 8 THEN connCart.BeginTrans
-------------------------------------------------------------------------------------------

I have moved the classic asp website to new hosting. Much of it seems to run without problems  but the above code fails with
--------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/shop/CartCode.asp, line 128
------------------------------------------------
Line 128 is the line above highlighted  with *****

I would appreciate some guidance on how to correct this.
Note: the code worked in the past with two other hosting companies.
I have now moved it to a new hosting company and this error has appeared.

thanks

Michael
Avatar of pateljitu
pateljitu
Flag of Canada image

Error code would mean there is problem with DNS used in connection

Please refer this article for error description:
http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html

Make sure DNS is created on NEW hosting environment and you using the correct DNS.

DNS creation:
http://www.devasp.com/samples/dsn_access.asp
ASKER CERTIFIED SOLUTION
Avatar of michaeldean99
michaeldean99
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of michaeldean99

ASKER

resolved by hosting company