classic asp connection to sql server

Problem with sql server database connection
This was working until the early hours of this morning!

Application("dbConnect") = "Driver={SQL Server};Server=xx.xxx.xxx.xx;DSN=mdean_stampsforsale;PWD=xxxxx"
      Application("dbUSER") = "mdean_stampsforsale"
      Application("dbPW") = "xxxxxxxx"
------------------

DIM conn
      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     ************************************************* line 71
      IF connCart.Properties("Transaction DDL") = 8 THEN      connCart.BeginTrans
----------------

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/LM/W3SVC/1/ROOT/global.asa, line 71

michaeldean99Asked:
Who is Participating?
 
hieloConnect With a Mentor Commented:
>>What occurred was that it is a new installation.
New installation of what ? If you are referring to DB Server, then based on your connection string:
 Server=xx.xxx.xxx.xx;

Verify the IP is still the same as the ip before the re-installation.
Also, make sure that the username and password on the DB server match what you are providing in the connection parameters.  You can also have them reset the password for that specific username for you.

If you are referring to the ?web server?, then:
did you re-create the DSN connection? Are you spelling the name correctly?
Also, see if the firewall is configured to allow traffic on that specific db server port.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please check this article to troubleshoot your connection:
http://www.experts-exchange.com/A_1881.html

in your case, you specify both DSN and Driver, which is "double work".
please fix it using the connection string suggestions from this link:
http://www.connectionstrings.com/sql-server-2005
0
 
michaeldean99Author Commented:
thanks. I have tried your suggested connection string but it doesn't work.
What occurred was that it is a new installation. The code was working fine until around 2am this morning and then the connection string failed.
Is there anything I could look at on the database (assuming I could connect to it!) or suggest to the hosting company that they look at?
0
 
sybeCommented:
> it is a new installation

Are you sure that the database is running, and that no firewall blocks access to it?
The code from http://www.connectionstrings.com should work. If not, it is not the syntax of the connection string that is wrong.
0
 
michaeldean99Author Commented:
thanks for your guidance.
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.

All Courses

From novice to tech pro — start learning today.