Brief description of the configuration method for connecting PHP to MSSQLServer in Linux (1. Sybase Library)

Source: Internet
Author: User
Tags mssqlserver sybase database
If you need to access the Microsoft SQL Server or Sybase database in Linux, the following software packages are recommended. SybaseCommondownload. sybase. compubase1192_linuxsybase-common-11.9.2-3.i386.rpmSybaseOpenClientdownload.sybase.compubase1192_linuxsybase-openclient-11. SybaseSQL Server

If you need to access the Microsoft SQL Server or Sybase database in 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 procedure is performed in versions earlier than RedHat 8 (not including 8). versions later than RedHat 8 seem to be in conflict with the Sybase library due to a system package upgrade, I have reported this problem to the PHP DEV TEAM, but it does not seem to have any solution. The same is true for other Linux releases that have been launched in close time.

SybaseOpenClient depends on SybaseCommon.

These two packages are mainly used to provide client connections to Sybase. because MSSQL and Sybase are well known, 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, perform some simple setup, 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, add such a configuration line.

Wrap these two packages before you configure PHP, and then add -- with-sybase-ct =/opt/sybase-11.9.2 in the configuration parameters of php, or -- with-sybase =/opt/sybase-11.9.2. Note: In the latest version of php, a -- with-mssql configuration option is added. this option is used with the FreeTDS Library and is not suitable for Sybase.

Other installation and configuration processes are omitted.

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.