Dreamweaver ASP connection string for godaddy.com

I'm using Dreamweaver to connect to a site on godaddy.com but I'm having problems setting it up to connect to the SQL server database I have there with ASP.
Anyone using godaddy and old ASP can tell me how to set up through dreamweaver a connection to the DB.
Thanks
bjamesjAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
LZ1Connect With a Mentor Commented:
Sorry.  Forgot you had SQL.
See if this site helps:
http://www.connectionstrings.com/default.aspx  
0
 
LZ1Commented:
My connection string looks like this:

Provider=Microsoft.Jet.OLEDB.4.0;Data source=d:\hosting\username\yourfile.mdb

Open in new window

0
 
bjamesjAuthor Commented:
I'm looking for a ASP/VB SQl server db connection string for godaddy.com.
Heres what I have so far but the server seems to eb wrong or at least thats the error I keep gettting

Driver={SQL Server};Server=whsql01.mesa1.secureserver.net;Database=mydatabase;Uid=db_username;Pwd=db_password;
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.