michaeldean99
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 .Connectio n")
conn.open Application("dbConnect"),A pplication ("dbUSER") ,Applicati on("dbPW") ******
'* Transaction START
DIM connCart
SET connCart = Server.CreateObject("ADODB .Connectio n")
connCart.open conn
IF connCart.Properties("Trans action 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
--------------------------
SET conn = Server.CreateObject("ADODB
conn.open Application("dbConnect"),A
'* Transaction START
DIM connCart
SET connCart = Server.CreateObject("ADODB
connCart.open conn
IF connCart.Properties("Trans
--------------------------
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
resolved by hosting company
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