PHP4.0.2 with MS SQL SERVER support

Anon

Im trying to compile PHP4.0.2 with MS SQL SERVER support for apache 1.3.12

Im under linux and the MS SQL SERVER will be on a windows machine on my local network.

How should I compile PHP?

./configure --with??

Do I need to download any source or sumthing before compiliing ?

I have searched this site and saw something about sybase ...

Problem is : I want to use mssql_connect and similar functions in my php scripts.

Thanks in advance

Anon

There is poor documentation in PHP for compiling with MSSQL support under Linux. Micrsoft SQL server is protocol-compitable with Sybase. So just go to the sybase site and download sybase-common-11_9_2-1_i386.rpm, edit the "interfaces" file and compile with sybase-ct support (!).

It'll work!

Anon

Ruud, thanks for your help but I dled that file and compiled PHP like :

--with-mysql --with-sybase-ct

and reports me the error of ctpublic.h not found. I didnt find that file called "interfaces" on my system too. Do you think im forgetting something?

The Sybase thing got installed under /opt/sybase-11.9.2

Thanks very much

Anon

[Partially from the PHP website, under Sybase-CT]

First get the linux ASE from sybase (maybe the ctlibs provided at php.net will do fine, too) Install the ASE rpm. (some distributions don't have system libs etc in the rpm database so you might get some dependency errors. If your systems fits the requirements install with "ignore dependencies") Recompile php with option

--with-sybase-ct=/dirtoyoursybasehome

Then you need to set the env variable for (at least)your apache user by export SYBASE=/dirtoyoursybasehome. Now you need to set up your servers (like DSNs for ODBC). Edit the file $SYBASE/interfaces and add your server entries (look for the example interfaces file in the sybase-ct driver that you can download from the PHP website. It doesn't work but it has an example "interfaces" file in it, the Sybase ASE is picky 😉:

Now you can check your config by using
$SYBASE/bin/isql -S SERVERNAME -U DBUSER -P PASSWD

Try this! If this works, you are sure that you have the Sybase CT drivers work. So if you get a prompt you have connected to your sybase! Hurray! Now you can try with php
$db=sybase_connect(server, user,pwd), and that's all!

Anon

Example interfaces-file:

---====[ interfaces ]====---
<servername>
query tcp eth0 <ipnr> 1433
master tcp eth0 <ipnr> 1433
---====[ EOF ]====---

with <servername> is the name you use to call your database-server, i suggest to make it the same as the Windows name of the MSSQL-server

and <ipnr> is the hostname or the ip-nr of the MSSQL-server.

Anon

Example interfaces-file (so you don't need the sybase-ct from the PHP website to get it, no TAB's!!):

---====[ interfaces ]====---
<servername>
query tcp eth0 <ipnr> 1433
master tcp eth0 <ipnr> 1433
---====[ EOF ]====---

with <servername> is the name you use to call your database-server, i suggest to make it the same as the Windows name of the MSSQL-server

and <ipnr> is the hostname or the ip-nr of the MSSQL-server.

Anon

I think I have all installed etc but I get this error when trying to connect to the MS SQL SERVER ( it's MS SQL SERVER 2000 )

./isql -S aura_bcn -U XXX -P XXX
CT-LIBRARY error:
ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

and the interfaces file looks like this :

aura_bcn
query tcp eth0 10.100.100.13 1433
master tcp eth0 10.100.100.13 1433

Is that an error of compatilibity with that 2000 server or do u feel it isnt?
Thanks Ruud

Anon

Hi,
What I wonder is whether we have to do anything on the MS SQL Server running on NT to be able to connect from Linux box.

thanks

Anon

I think you only need to be sure sql server is listening to tcp/ip sockets, as far as I remember, by default it is set up only for named pipes.

Anon

Hello,

how did you get rid of the ctpublic.h not found error on make?

Thanks

J.M.

Anon

Check the following microsoft knowledge base article.
It seems that SQL Server 7.0 needs a patch
and SQL server versions after that are not warantied to
work with all the sybase clients.

http://support.microsoft.com/support/kb/articles/Q239/8/83.ASP