Introduction to the configuration method of PHP connection MSSQLServer under Linux (I, Sybase library) _php Tutorial

Source: Internet
Author: User
Tags mssqlserver sybase sybase database
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 caused a conflict with the Sybase library, which I had reflected to the PHP DEV TEAM, but there seemed to be no workaround. The same problem applies to Linux releases that have been released at similar times.
Sybaseopenclient relies on Sybasecommon.
The main role of these two packages is to provide client connections 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, do some simple setup work, in the/OPT/SYBASE-11.9.2/directory to add a interfaces file, the content is as follows:
DbServerName
Query TCP tds7.0 dbserveripaddress dbservertcpport
Master TCP tds7.0 dbserveripaddress Dbservertcpport
If you need to connect to more than one server, add such a configuration line.
Before you configure PHP, put these two packages, and then add--with-sybase-ct=/opt/sybase-11.9.2 to the configuration parameters of PHP, 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 in conjunction with the FreeTDS library and is not suitable for the Sybase library.
The other installation configuration process is slightly.

http://www.bkjia.com/PHPjc/629873.html www.bkjia.com true http://www.bkjia.com/PHPjc/629873.html techarticle If you need to access a Microsoft SQL server or Sybase database under Linux, the following packages are recommended. Sybasecommonhttp://download.sybase.com/pub/ase1192_linux/sybase-common-11.9.2-3.i38 ...

  • 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.