persistent connection
Sam Sam
s4m at lycos.com
Tue Aug 22 09:42:18 EDT 2000
dear guys and girls.. gee i need your help.. I've compiled freetds with php-4.0.1pl2 and apache_1.3.12 and imap.. it works but i've to connect with persistent connection (mssql_pconnect) if I use sybase_connect I can't fetch the next record.. here is my example code...
$sam=mssql_connect("10.28.1.50","xxx","xxx")mssql_select_db("Database_Db_Web",$sam);
$SQL="select * from Area";
$jes=mssql_query($SQL,$sam);
$baris=mssql_num_rows($jes);
$kolom=mssql_num_fields($jes);
print("Jumlah Baris ".$baris);
print("Jumlah Kolom ".$kolom);
for ($j=0;$j<$baris;$j++) {
for ($sam=0;$sam<$kolom;$sam++){
print($Rs[$sam]."|");
}
$Rs=mssql_fetch_array($jes);
print("<br>");
}
it doesn't work.. but if I change it into mssql_pconnect it works
Anyway i've setup another server, it worked with the mssql_connect.. I used the same versions...
here is my setup steps:
./configure --prefix=/data/freetds --with-tdsver=4.2
make
make install
export SYBASE=/data/freetds
export LD_LIBRARY_PATH=/data/freetds/lib
in php
./configure --with-apache=../apache_1.3.12 --with-sybase-ct=/data/freetds --with-mysql --with-imap=/data/imap4.7c/c-client --with-xml
make
make install
in apache
./configure --prefix=/data/apache --activate-module=src/modules/php4/libphp4.a
make
make install
any help, suggestions, ideas would be appreciated...
cause i'm desperated now..
thx
Send your favorite photo with any online greeting!
http://www.whowhere.lycos.com/redirects/americangreetings.rdct
More information about the FreeTDS
mailing list