Hi,
I am trying to establish a PDO connection to a remote database (running on a different server than my php app is) as follows:
$dbh = new PDO('mssql:host=www.myaddress.com;dbname=test', 'user', 'pass');
I get this error:
Error!: SQLSTATE[01002] Unable to connect: SQL Server is unavailable or does not exist. Specified SQL server not found. (severity 9)
Can anyone tell me if my dsn string is correct inside of the PDO function, or if I am missing any needed info? The documentation is unclear to me and doesn't contain an example of connecting to a remote db:
http://us3.php.net/manual/en/pdo.construct.php
Thanks for any help,
gm