• 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.

thanks

Michael
0
michaeldean99
Asked:
michaeldean99
  • 2
1 Solution
 
pateljituCommented:
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
0
 
michaeldean99Author Commented:
thanks for your help. the issue was caused by problems with the hosting setup
0
 
michaeldean99Author Commented:
resolved by hosting company
0
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