How to connect to Sybase via PHP

php sybase dbo
zwiebelspaetzle picture zwiebelspaetzle · Jan 18, 2013 · Viewed 12.4k times · Source

I'm trying to connect to a Sybase database with PHP5. I believe I've successfully compiled PHP with PDO_DBLIB, as phpinfo() lists dblib under PDO drivers, and freetds as the pdo_dblib flavour.

However, when I try to test a connection, I get an error reading:

'PDOException' with message 'could not find driver'

I'm trying to connect to a server on my LAN with this code:

$dbh = new PDO("sybase:host=192.168.1.xxx;dbname=[database-name]", '[user]', '[pass]');

Any suggestions would be greatly appreciated!

Answer

gumaterror picture gumaterror · Jan 16, 2015

You should use dblib instead of sybase, like this:

$dbh = new PDO("dblib:host=192.168.1.xxx;dbname=[database-name]", '[user]', '[pass]');

Related questions

PHP PDO installation on windows (xampp)

I am trying to develop a web app that can connect to as many different databases as possible on PHP. PDO (http://www.php.net/manual/en/book.pdo.php) seems to be the right interface for it but I …

Read More
PDO To Connect to MSSQL Over MSSQL_* Functions

There is a range of mssql_* Which are not in the depreciation process. They work the same as mysql_* functions; they need to me manually escaped, please find the link to the manual below: http://uk1.php.net/manual/en/…

Read More
How do I check if a string contains a specific word?

Consider: $a = 'How are you?'; if ($a contains 'are') echo 'true'; Suppose I have the code above, what is the correct way to write the statement if ($a contains 'are')?

Read More