Microsoft SQL

Anon

Hey

what is the best way of connection to a MsSQL server via PHP from my Linux/apache server.

how do i set PHP up to use MsSQL, if anybody has done this before i would like some hints 🙂

Regards

Anon

woohoo no answers 🙂, i try some kinda of ODBC then, i had hope that i could compile MsSQL support into php some way

Anon

Hi,
I was thinking along the ODBC lines myself but it surely must be possible you can do it with windoze and even with windows php communicates with the SQL server machine through TCP/IP.

So why not Unix, DOH!!!

if you found the solution, could you drop me an email ive been struggling with the same problem.

Nic.

Anon

Hi,

apparently if you wish to connext to a SQL server you should go to sybase.com and download their ASE software for linux. Once this is installed on your linux box php uses sybase to connect to the SQL server. However i have had some problems trying to install sybase, so i cant say if everything works great with this approach.

good luck

Anon

The following was posted at http://www.php.net/manual/function.mssql-connect.php:

I have finally set up PHP 4.0 with Apache in linux with sybase to connect to MSSQL Server 7.0.. I compiled php like this:

I installed the 3 sybase rpms from http://linux.sybase.com/

Then I compiled PHP like this:

./configure --with-apache=../apache_1.3.12 --with-sybase=/opt/sybase-11.9.2/

And I edited /usr/local/lib/php.ini, there is a section about sybase, I modified:

sybase.interface_file = "/opt/sybase-11.9.2/interfaces"

And last mi /opt/sybase-11.9.2/interfaces file is like this:

misql_HOST

query tcp ether 192.168.0.2 1433

And It worked GREAT!!!!!!.

luciano@n4w.com.ar
13-Jul-2000 11:44

I have finally set up PHP 4.0 with Apache in linux with sybase to connect to MSSQL Server 7.0.. I compiled php like this:

I installed the 3 sybase rpms from http://linux.sybase.com/

Then I compiled PHP like this:

./configure --with-apache=../apache_1.3.12 --with-sybase=/opt/sybase-11.9.2/

And I edited /usr/local/lib/php.ini, there is a section about sybase, I modified:

sybase.interface_file = "/opt/sybase-11.9.2/interfaces"

And last mi /opt/sybase-11.9.2/interfaces file is like this:

misql_HOST

query tcp ether 192.168.0.2 1433

And It worked GREAT!!!!!!.

Luciano Ramos

Anon

Hi Kurt,
Can you tell us what these 3 rpms and the order you istalled them. What are their prerequisites, if any.

Ýf you share your experience , I will be greatfull,

by the way, did you rebuilt apache with
--activate-module

regards,

Anon

Hi Zekeriya,

the package i downloaded from sybase was ASE 11.9.2 which has the following rpms :
sybase-ase-11.9.2
sybase-common-11.9.2
sybase-doc-11.9.2
sybase-openclient-11.9.2

I installed them and went through the steps of building and configuring the sybase server which was'nt neccessary as far as i can tell!! The rpms just need to be installed. I cant remember the order to install them but its not important.

After doing this i didnt encounter nay problems.

good luck