Ok, so I am trying to connect to a remote (not on our server) MS SQL database with PHP. My host has enabled/installed ODBC. What is the next step to connect? I have a local connection set up by creating a DSN and using Access but I need to be able to connect from the web. I have tried the DSN-less example from php.net using my credentials but it doesn't work (neither does it return an error).
// Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);
I don't even know if the server setup is capable of attempting the connection. What should my next step be to complete this connection process? I assume in the above example, perhaps the driver is wrong? when I echo the $connection, there is nothing, not a false or 0, just undefined.
