microsoft odbc driver for sql server on linux

cd unixODBC-2.3.0/Īt a command prompt, type the following command: CPPFLAGS='-DSIZEOF_LONG_INT=8'Īt a command prompt, type the following command: export CPPFLAGSĪt a command prompt, type the following command. On your Linux computer, execute the following command: cd ~/Downloads/Ĭhange to the unixODBC-2.3.0 directory. To install new packages, run following command line (The installing user must have write privileges to the /opt directory by default.) yum install php httpd php-odbc php-pear.noarch php-pecl-apc php-xml php-xmlrpc php-tidy php-intl php-imap php-pecl-memcache glibc libuuid1 krb5 openssl gcc unixodbcĪdd these two lines to /etc/httpd/conf/nf SetEnv ODBCSYSINI /etcĬlick the Download link (unixODBC-2.3.0), on the left side of the page.Ĭlick the Download link, on the next page, and save the file in '~/Download' folder yum remove php httpd php-odbc php-pear.noarch php-pecl-apc php-xml php-xmlrpc php-tidy php-intl php-imap php-pecl-memcache glibc libuuid1 krb5 openssl gcc unixodbc

Run the following command line to remove previous installations. In addition, the server must also have TCP/IP connections enabled with a static port defined (I will be using the default of 1433), and the firewall on the host for the SQL Server must allow connections to SQL Server on the static port. This requires a restart of the SQL Server service if changed.

Below are steps to install, configure and start using the Microsoft SQL Server ODBC Driver for Linux, and using it from PHP - it assumes that you have SQL Server already available and configured to accept connections over TCP/IP, also that you have some familiarity with Linux.įirst, the SQL Server (and the appropriate database) must be configured for Windows and SQL Server Authentication.

Microsoft odbc driver for sql server on linux