Connecting DreamweaverMX to Linux

[DarrenH]

I am attempting to create PHP pages in Dreamweaver MX and connect to MYSQL.
The database exists on my server and i get the following error when testing
the connection in Dreamweaver

A server timeout has occured. here are the possible reasons.
1. Please make sure that the web server is up and running.
2. Please verify that the ODBC DSN exists on the testing server.

My hosts advise the following:

Please note you are on a Linux server that doesn't support ODBC

They suggest that i switch to a windows server and advise that this is not as secure and that not all PHP functions are suuported, which is no good to m
e.

Does anybody know how to connect Dreamweaver to my existing server?

[till]

Maybe your mysql server listens only on localhost or it is blocked by a firewall. Please execute:

netstat -tap

and

iptales -L

on your server and post the output.

[DarrenH]

Thanks for that,

How exactly do i run these options?

[edge]

You will need SSH access to the server.

My guess is that this is not your server, and that you do not have SSH access to it.

My hosts advise the following:

Please note you are on a Linux server that doesn't support ODBC

They suggest that i switch to a windows server and advise that this is not as secure and that not all PHP functions are suuported, which is no good to m
e.