26 Dec 2013 22:34:47 Jason Fisher posted:
Trying to connect to an mssql remote server.
I can connect no problem with a simple php connection string embedded in my index.php page. I also can connect via MS Access using a File DSN with the same credentials.
However, when using Database Connector PHP "Manage Database Connections" dialogue box with the same credentials, I get the following error:
"Error using this Database Connection! Server response: could not find driver".
The remote server is a SQL Server Cluster that is securely maintained by my institution, so I don't have access to the fine-tuning of the server configuration - I only have access to the specific SQL instance and database that was set up for me. Is it possible that the cluster doesn't support a PHP connection? That seems unlikely because I can connect if I embed the following code in my webpages:
$hostname_connectSQL = "sqld1204.myinstitution.org\db04";
$databasename_connectSQL = "databasename";
$username_connectSQL = "username";
$password_connectSQL = "password";
$connectSQL = mssql_connect($hostname_connectSQL, $username_connectSQL, $password_connectSQL) or die("Couldn't connect to SQL Server on $hostname_connectSQL"