If you need to use PHP to connect to a Microsoft SQL Server 2005 database on a Linux system, our common way to connect to a database is to use ODBC to connect.
FreeTDS provides an open source client for the TDS protocol for Linux systems.
Environment:Development Board: Freescale 2.6 armv71, the system is read only , the only path to read and write is/TMP/SD (this is an SD card). The program is placed under/tmp/sd/transfer (instead of the run path below), and the SQL statement is
This article describes three things: 1: 2: Environment configuration 3: Operation script content 1: MS has never provided SQLServerforLinux, so do not try to install SQLServer on Linux, however, you can use ODBC to connect to the SQL Server database
Use php (4.x) on a Linux machine to connect to the SQL server2000 Database
Apt-get install php-odbc unixODBC-devel unixODBC
Or
Yum install php-odbc unixODBC-devel unixODBC
And then from here (http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-
PHP naturally has good support for MySQL, but it takes a while to work with SQL Server in PHP. Today, just one project in the team needed to operate SQL Server in PHP, so it helped to configure the environment.
First, the system version of the
First, install the ODBC driver unixODBC on Linux. Download www.unixodbc.org and install it. You can also select a graphical interface for installation.
First, install the ODBC driver unixODBC on Linux. Download www.unixodbc.org and install it. You
A very strange project was created just a few days before the title was proposed. our company developed a set of SP short message service software based on the SGIP Protocol of China Unicom to provide China Unicom's 130 short-term services. This
Ask questions
A few days ago did a very strange project, my company developed a set of China Unicom SGIP Protocol, SP-terminal short Message service software, providing unicom 130 SMS service. The system is under Windows 2000, the database is
In linux, connect php to sqlserver2000-Linux Enterprise Application-Linux server application information. For details, refer to the following section. Connect php (4.x) to the SQL Server database on a linux machine
Apt-get install php-odbc unixODBC-
Server|sqlserver
Ask a question
A few days ago did a very strange project, my company developed a set of China Unicom SGIP Protocol of the SP terminal Short Message Service software, to provide unicom 130 SMS services. This system is under Windows 20
PHP connection to MS SQL Server under LinuxAnalyze problemsPHP scripts Read and write SQL Server is not a problem, in Apache for Windows and Windows IIS can work very well, generally can be connected via ODBC or SQL Server client, which is available
PHP connection to MS SQL Server under LinuxPHP scripts Read and write SQL Server is not a problem, in Apache for Windows and Windows IIS can work very well, generally can be connected via ODBC or SQL Server client, which is available under Windows.
Catalogue [-]
How to install mssql.so
How to install Pdo_lib. So
How to install PDO_ODBC. So
Author: Roban Lee ([email protected])There are many ways to connect MSSQL using PHP under Linux, depending on the environment, you can
Ubuntu has unixodbc. To connect to MSSQL or SYBASE, you need to install it first. To compile freetds, you need to install the packages unixodbc, unixodbc-bin, and unixodbc-dev. After installation, you can use tools such as ODBCConfig and DataManger.
Generally connected to the database, you must install the client, I generally do not write blog writing principles, but later found to look back to their own writing I do not understand, so this chapter blog will be a bit more original rational
One, under Windows PHP Connection SQL Server 2005
Settings: Installed Windows operating system (WIN7 or XP are available, other systems are not tested), under the C drive, PHP related files are located under C:/php, the configuration file php.ini
A test environment
Operating system Red Hat as 5.5
Database
SQLServer2000 installed in Windows XP Professional, I assume that the database has a user autotest password is autotest, the database file is Atsdb
Attention:
1 MS has never provided
One, Windows PHP connection SQL Server 2005
Setup: Installed Windows operating system (Win7 or XP, other systems are not tested), under C disk, PHP's related files are located under C:/php, the configuration file php.ini is located under C:\Windows.
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.