Dreamweaver

suarve · 7 Jul 2008 at 17:38

Hi,

I have my hosting with tsohost.co.uk and wish to connect to my sql databse using dreamweaver. Can anyone provide settings i can use in the site definition E.g. what address to use the 'machine running the sql server', as every url i try fails :/

Thanks

Ross1234 · 7 Jul 2008 at 17:45

try their support. they are extremely helpful.

try localhost as the url

AbsenceJam · 7 Jul 2008 at 17:50

The address will be the address of the server so using your domain will work, you'll have to add your own IP/host to cpanel though. It's under mySQL then Access Hosts.

suarve · 7 Jul 2008 at 17:54

AbsenceJam said:
The address will be the address of the server so using your domain will work, you'll have to add your own IP/host to cpanel though. It's under mySQL then Access Hosts.

Yup, already added my host mate. Have already tried using my domain (myuser.tsohost.co.uk) as sql server too with no luck.

suarve · 7 Jul 2008 at 20:10

This is silly now. Support have recommended me try a googled link describing how to set up general site definitions. For the sql server i have tried the ip of my shared hosting account, the hostname and (as suggested) localhost. All with no luck. Someone on here must have set up a database connection using dreamweaver and tsohost. This is usually so easy to setup.

daz · 7 Jul 2008 at 20:15

To see whether there's anything preventing you from connecting, you can try opening a telnet to the MySQL server.

Open a command prompt - Start > Run > cmd.exe and type the following:-

telnet yourdomain.co.uk 3306

(Obviously replacing yourdomain.co.uk with your actual domain)
You'll see the MySQL server version plus some gibberish, but it will narrow down whether there's a problem with your dreamweaver settings or whether there's some other general connection issue.

suarve · 7 Jul 2008 at 20:20

Humm. Just tried that and it displays the server version with '-max-log' on the end. It also says connection host lost instantly too.

daz · 7 Jul 2008 at 20:26

suarve said:
Humm. Just tried that and it displays the server version with '-max-log' on the end. It also says connection host lost instantly too.

Telnet isn't supposed to connect to a MySQL server. It means there is something wrong with the dreamweaver settings...

suarve · 7 Jul 2008 at 20:30

bah! just tried localhost:3306 and it works. DW must treat the remote host as the local machine.