Home >Backend Development >PHP Tutorial >A brief description of the configuration method of PHP connecting to MSSQLServer under Linux (1. Sybase library)_PHP tutorial
A brief description of the configuration method of PHP connecting to MSSQLServer under Linux (1. Sybase library)_PHP tutorial
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-07-13 17:08:09818browse
If you need to access Microsoft SQL Server or Sybase database under Linux, the following software 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 process passed in versions before RedHat 8 (excluding 8). Versions after RedHat 8 seem to conflict with this Sybase library due to a system package upgrade. , I have reported this problem to PHP DEV TEAM, but there seems to be no solution. Other Linux distributions launched at similar times have the same problem.
SybaseOpenClient depends on SybaseCommon.
The main function of these two packages is to provide client connections to Sybase. Because of the well-known relationship between MSSQL and Sybase, 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, make some simple settings Work, add a file named interfaces in the /opt/sybase-11.9.2/ directory, the content is roughly as follows:
DBServerName
query tcp tds7.0 DBServerIPAddress DBServerTCPPort
master tcp tds7.0 DBServerIPAddress DBServerTCPPort
If you need to connect to multiple servers, just add such a configuration line.
Wrap these two before you configure PHP, and then add --with-sybase-ct=/opt/sybase-11.9.2, or --with-sybase=/opt to the PHP configuration parameters /sybase-11.9.2 is enough. Note that in recent versions of php, there is an additional configuration option --with-mssql. This is used with the FreeTDS library and is not suitable for the Sybase library.
Other installation and configuration procedures are omitted.