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:

<?php
$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";
?>

thoughts?
thanks,
--Jason

Hi Jason,

The Database Connector uses PHP PDO to make connections. So on the web server that you run your site on, you must make sure PDO is enabled in php.ini and also the right PDO drivers are installed.

So for connecting to MS SQL Server you should just install the PDO MSSQL Driver to make it work.

Note I mean the web server, not your secure ms sql database server.
See www.php.net/manual/en/ref.pdo-sqlsrv.php

Greetings,
George

Thanks George --
I investigated further with the folks who maintain our web server environment.
They tell me that for some reason, PDO MSSQL is difficult for them to install.
However, they do support FreeTDS, and they say they can add pbo_obdc.so to the web server. If they make that addition, would I be able to use the Database Connector interface if my webserver is running the freeTDS implementation as its method for communicating with mssql?
thanks,
--Jason

I am having the same issue. My ISP will not change anything on their server to accommodate me. What is the workaround for this. I can't even get the extension to work on my local SQL Server.

Locally, I have installed the correct drivers as specified in the link above. I have copied these drivers to my extensions folder. Still not working. Can you advise? If I can't get this to work, I will need a refund.

I can connect to MySQL databases, but I can already do that in Dreamweaver. I need this extension for SQL Server and Access. While I'm on the subject, I don't even see an Access option. Even if I choose custom as the database type. In the documentation, it says I can connect to an Access DB, but I can't figure out how.

I'm running PHP version 5.6.3 and have installed the correct drivers. However, when I restart XAMPP, I get the following error: PHP Startup: Unable to load dynamic library. 'C:\xampp\php\ext\php_pdo_sqlsrv_56_nts.dll' - The specified module could not be found. The DLL files ARE in this folder.

I HAVE entered this into my php.ini file:
extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_nts.dll

Thank you.

I currently have


pdo_sqlsrv
pdo_sqlsrv support enabled
ExtensionVer 4.3.0

PDO support enabled
PDO drivers sqlsrv, mysql, odbc

And I am still getting an error on driver not found.

Hi Don,
Please explain a little more detailed - what database are you trying to connect to? What version of the database connector are you using?