与oledb和odbc混淆

Question

Hey guys i have 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 ??..

Hope you guys can help me out ..Thanks in advance

Answer 1

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?