php4 with sybase or freetds

Anon

Hi..

im trying to compile php4 with tds. I tried with both sybase and freetds but come to no vail. Every time i compiled, i came to error.. no reference to function.. bla bla..

Anybody got compile?.. any help

Anon

Did you configure PHP with --with-sybase=/usr/local/freetds?
Are you sure, you set the enviroment variables (SYBASE, LD_LIBRARY_PATH)?

Anon

I'm using php-4.0.4pl1 and freetds-0.51 on a SuSE 7.0 system, and it works

run configure in freetds with the following options

./configure --with-tdsver=4.2 --enable-msdblib --enable-dbmfix --with-gnu-ld --enable-shared --enable-static
(read INSTALL for tdsver!)

compile and install

you have to edit "php_sybase_db.c" in
php-4.0.4pl1/ext/sybase and change all "dbopen" calls to "tdsdbopen" ( rows 382, 418, 465 )

now run configure in the php source directory:

./configure --enable-track-vars --with-apxs --with-sybase=/usr/local/freetds ....

compile and install

you must set the SYBASE environment variable and expand the lib-searchpath

for example:

SYBASE=/usr/local/freetds

and expand the library seachpath

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib
export SYBASE LD_LIBRARY_PATH

alternatively you can insert
/usr/local/freetds/lib in /etc/ld.so.conf and run ldconfig

for apache:
insert the following line in httpd.conf
SetEnv SYBASE /usr/local/freetds

finally you have to setup freetds. edit "interfaces" in
/usr/local/freetds

for example insert:

db1
query tcp tds4.2 192.168.1.1 1433
master tcp tds4.2 192.158.1.1 1433

have fun
Rene

Anon

Hi,
I'm using php-4.0.5, do I have to edit "php_sybase_db.c"? I edited it b4 but my apache couldn't even start. I left everything as default, apache can be start but seems freetds doesn't work at all. It doesn't come out any error during compile or installation but just cannot make connection.

mssql_connect("myserver","usr","pwd" ) or die("connection fail");

always display "connection fail" in my case. Need help. 🙁

Anon

how do you make a store procedure call with FreeTDS?

I'm using PHP and FreeTDS to connect to MS SQL, and i'm trying to make a sample store procedure call to MS SQL by means of PHP's sybase fucntion calls. Can you show me a simple lines of PHP for demoing purposes?

Thanks.