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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
hieloCommented:
>>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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
michaeldean99Author Commented:
thanks for your guidance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.