A brief introduction to the configuration method of PHP connection MSSQLServer under Linux (first, Sybase library)
Source: Internet
Author: User
If you need to access a Microsoft SQL server or Sybase database under Linux, the following packages are recommended.
Sybasecommon http://download.sybase.com/pub/ase1192_linux/sybase-common-11.9.2-3.i386.rpm
Sybaseopenclient http://download.sybase.com/pub/ase1192_linux/sybase-openclient-11.1.1-3.i386.rpm
The following procedure was passed before RedHat 8 (excluding 8), and the version after RedHat 8 appeared to be due to a system package upgrade that was in conflict with Sybase's library, a problem I had reflected to the PHP DEV team, but there seemed to be no workaround. Linux releases of other similar times have the same problem.
Sybaseopenclient depends on the Sybasecommon.
The main role of these two packages is to provide client connectivity to Sybase, because MSSQL and Sybase are well known relationships, and their underlying protocols are roughly the same, so ...
# RPM-IVH sybase-common-11.9.2-3.i386.rpm sybase-openclient-11.1.1-3.i386.rpm
The default installation location is/OPT/SYBASE-11.9.2/
After the installation is complete, do some simple setup work, add a interfaces file in the/OPT/SYBASE-11.9.2/directory, which is roughly as follows:
DbServerName
Query TCP tds7.0 dbserveripaddress dbservertcpport
Master TCP tds7.0 dbserveripaddress Dbservertcpport
If you need to connect multiple servers, add such a configuration line.
Before you configure PHP, put the two wrappers on, and then add--with-sybase-ct=/opt/sybase-11.9.2 to the PHP configuration parameters, or--with-sybase=/opt/sybase-11.9.2. Note that in the most recent version of PHP, there is a--with-mssql configuration option, which is used with the FreeTDS library, and is not suitable for Sybase library.
The other installation configuration process is slightly.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service