Add new comment

Thanks for the great article and and for important discussions by all of you.

I have tried with

$db = new PDO("dblib:host=243.234.234.232;dbname=dbname", "user", "pswd");

and got

Unable to open database.
Error message:

exception 'PDOException' with message 'could not find driver' in /var/www/html/ll/test/test.php:7 Stack trace: #0 /var/www/html/ll/test/test.php(7): PDO->__construct('dblib:host=198....', 'hipcask', 'logic9944') #1 {main}.

When I use

$db = new PDO('odbc:Driver=FreeTDS; Server=63.45.32.34; Port=1433; Database=database; UID=user; PWD=pswd;');

I get

Unable to open database.
Error message:

exception 'PDOException' with message 'SQLSTATE[IM002] SQLDriverConnect: 0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified' in /var/www/html/ll/test/test.php:5 Stack trace: #0 /var/www/html/ll/test/test.php(5): PDO->__construct('odbc:Driver=Fre...') #1 {main}.

Any help would be greatly appreciated.