Error connecting PHP to SQL Server via ODBC Linux

Question:

I'm making a connection in windowns via php to SQL SERVER and it's going normal, on a machine where the php server is linux is giving the following error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found' in /var/www/html/sql/index.php:8 Stack trace: #0 /var/www/html/sql/index.php(8): PDO->__construct('odbc:Driver={SQ...') #1 {main} thrown in /var/www/html/sql/index.php on line 8

How do I enable the odbc driver on linux?

LINUX:

PRETTY_NAME="Debian GNU/Linux 8 (jessie)"
NAME="Debian GNU/Linux"
VERSION_ID="8"
VERSION="8 (jessie)"
ID=debian
HOME_URL="http://www.debian.org/"
SUPPORT_URL="http://www.debian.org/support"
BUG_REPORT_URL="https://bugs.debian.org/"

APACHE:

Server version: Apache/2.4.10 (Debian)
Server built:   Nov 28 2015 14:05:48

SQL:

Microsoft SQL Server Standard Edition (64-bit)
Microsoft Windows NT 6.1 (7601)
NT x64
10.0.2531.0

PHP:

PHP Version 5.6.22-0+deb8u1

Answer:

1) First, take a look at the nolibsqlncli-11.0.so.1790.0 permissions, to see if apache can write and read.

2) It is necessary to look at the lib dependencies and see if there are any missing.

ldd /opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0

3) If you are using CENTos try disabling SELinux.

Scroll to Top
AllEscort