• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

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.


  • 2
1 Solution
Error code would mean there is problem with DNS used in connection

Please refer this article for error description:

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

DNS creation:
michaeldean99Author Commented:
thanks for your help. the issue was caused by problems with the hosting setup
michaeldean99Author Commented:
resolved by hosting company
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now