Need some Basic Help...

[WillyWonka84]

I need some basic help connecting to a SQL database I created on a remote server. I edit and update dreamweaver pages here on my local PC then when ready, upload them to the server. I am trying to just create a connection to where a dreamweaver page can show the info in the data base. After that, I want to be abel to input data. Some info is below to help out:

my local PC is PC125
my server is SRV304
domain is example.com


Someone please help so I get over this hump. Usaully its something that Im overlooking. Thanks!

[juresti]

No sure exactly I used this post to help me connect to the GoDaddy server.

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=189&threadid=890853&hi...

[fatman84]

Thanks, but Im still learning about trying to connect a sql database to my dreamweaver page. In the source code, where would you even put the code? I believe I would just put whats below:

Server=SVR304.example.com;Database=WILLS DATABASE;Trusted_Connection=True;
Connection String: "not sure"

I dont know what to put for my connection string....Would this work?

[juresti]

Setup a custom connection string
Connection Name: connYourName (whatever you want the connection to be named)
Connection String: "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\hosting\yoursite\access_db\yourdatabasename.mdb"

Where "yoursite" = your site url without the .com/.org
and "yourdatabasename" = the name of your database