Microsot odbc driver 11 for sql server driver#
Later versions (13 and 17) of this driver supports more recent versions of SQL Server. Note that this driver supports SQL Server 2005 - 2014. The third restarts the Apache web server. The Microsoft ODBC Driver 11 for SQL Server provides native connectivity from Windows, Linux, & macOS to SQL Server and Azure SQL Databases.
Next, we execute three commands from the shell. Now edit /etc/odbc.ini and add a section like this (change to your database server IP): ĭescription=My Sample ODBC Database Connection Odbcinst -q -d -n "SQL Server Native Client 11.0"
Microsot odbc driver 11 for sql server install#
install.sh install -lib-dir=/usr/local/lib64 -accept-license Run the following series of commands, wget C99FC5535680/RedHat6/msodbcsql-.0.tar.gzĪnd press enter, and then cd msodbcsql-.0Īnd press enter, and then. configure -prefix=/usr -libdir=/usr/lib64 -sysconfdir=/etc -enable-gui=no -enable-drivers=no -enable-iconv -with-iconv-char-enc=UTF8 -with-iconv-ucode-enc=UTF16LEĪt a command prompt (logged in as root), type the following command make 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. PHP 5.6,, host '' conInfo array('Database'>'', 'UID'>'', 'PWD'>'') con sqlsrvconn. 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.
0 kommentar(er)
