Search code examples
phppdooledboledbconnection

Confused with oledb and odbc

I heard about oledb and odbc, and I know both are database programming interfaces. I am trying to establish an oledb connection with the php script.

I have mysql server 2012 running on my computer. I know how to create an odbc connection with pdo in php like

PDO::OLEDB_ATTR_USE_ENCRYPTION,PDO::OLEDB_ATTR_USE_CONNECTION_POOLING etc.

But I need to know where can I execute this php script with oledb connection. Do we want to download any seperate oledb driver for using it on sql server?

Solution

  • Your server needs the drivers, which are downloadable (google for the drivers). PHP comes with the pdo-dll's, you just need to enable them in your php.ini file, e.g.: extension=php_pdo_odbc.dll

    For more information: http://php.net/manual/en/pdo.installation.php

    And what is the difference between OLE DB and ODBC data sources?