{"id":20327,"date":"2022-03-25T13:45:52","date_gmt":"2022-03-25T12:45:52","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-portal\/installers-guide\/installing-oracle-pdo-and-ms-sql-extensions\/"},"modified":"2024-06-07T12:57:45","modified_gmt":"2024-06-07T10:57:45","slug":"installing-oracle-pdo-and-ms-sql-extensions","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-portal\/installers-guide\/installing-oracle-pdo-and-ms-sql-extensions\/","title":{"rendered":"Installing Oracle PDO and MS SQL Extensions"},"content":{"rendered":"
\n

In order to be able to make external SQL connections, such as ORACLE or Microsoft SQL SERVER, it is necessary to configure PHP PDO extensions: http:\/\/php.net\/manual\/fr\/book.pdo.php<\/a>.<\/p>\n

Drivers Microsoft SQL SERVER<\/strong><\/h2>\n

Windows<\/strong><\/h3>\n

The SQL to SQL Server connection driver is pre-installed and configured by default since version 6.9.0 of Open Bee\u2122 Portal.<\/p>\n

Linux<\/strong><\/h3>\n

The mssql.so<\/a><\/em><\/strong> extension offers a driver for php to connect to a Microsoft SQL Server<\/span><\/strong> database.<\/p>\n

To successfully enable the connection to a Microsoft SQL Server<\/span><\/strong> database ,<\/span>simply run the following two commands to install the mssql module:<\/p>\n

\n
\n
 apt-get install -f php5-sybase -y --force-yes\n pear install --nodeps MDB2_Driver_mssql<\/pre>\n<\/div>\n<\/div>\n
 <\/strong><\/p>\n
ORACLE<\/strong><\/h2>\n
Windows<\/strong><\/h3>\n
The pdo_oci<\/strong><\/em> extension offers an Oracle driver for php<\/em> so that it can connect to the Oracle<\/strong> database.<\/p>\n