Connect php to sqlserver2000 in linux

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-devel unixODBC

Or

Yum install php-odbc unixODBC-devel unixODBC

Then from here (http://ibiblio.org/pub/Linux/ALP.../freetds-stable.tgz) The current freetds source code

Cd/tmp

Wget http://ibiblio.org/pub/Linux/ALP.../freetds-stable.tgz

Tar xzvf freetds-stable.tgz

Cd freetds -*

./Configure? Prefix =/usr/local/freetds? With-tdsver = 8.0? With-unixodbc =/usr

(Because it is connected to SQL server2000, we use "? With-tdsver = 8.0 ")

Make; make install

Vim/usr/local/freetds/etc/tds. driver. template

Insert in file:

[FreeTDS]
Description = v0.64 with protocol v8.0
Driver =/usr/local/freetds/lib/libtdsodbc. so

(The freetds version here is 0.64)

Then install the driver

Odbcinst-I-d-f/usr/local/freetds/etc/tds. driver. template

Create a dsn.

Vim/usr/local/freetds/etc/tds. datasource. template

Content:

[MSSQLTestServer]
Driver = FreeTDS
Description = test sample database
Trace = No
Server = 192.168.1.1
Port = 1433
Database = testdb

Then

Odbcinst-I-s-f/usr/local/freetds/etc/tds. datasource. template-l

Restart apache

Now php supports connecting to the SQL Server database.