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?
Advertisement
Answer
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?