I've got a strange situation. I have followed all the directions on how to compile FreeTDS and PHP 4.3.10 to enable MSSQL support. Everything compiles fine works from the command line, but the MSSQL functions fail when I attempt to run them through the Netscape/iPlanet/SunOne plug in.
I'm running RedHat 2.1AS on a dual processor Xenon with 2G of ram. My webserver is SunOne(iPlanet) version 6.1. I am also running version 4.0.1 of SunOne ASP(Chilisoft) Here's what I've done: Built FreeTDS 0.62.4 with the following: ./configure --with-tdsver=8.0 --enable-msdblib --enable-dbmfix --with-gnu-ld It works and I can connect to my database with tsql. I built PHP like this: ./configure --with-nsapi=/opt/iplanet --with-mysql=/usr --prefix=/usr/local --enable-fastcgi --with-zlib --enable-dbase --enable-ftp --with-openssl --with-mssql=/usr/local I am running the Zend_Optimizer2.5.7 and IonCube extensions. I can see that MSSQL support is compiled in from phpinfo If I run this from the command line: php -r '$con= mssql_connect("<mydb>","<uid>","<pwd>"); mssql_select_db("<dbname>",$con); $rs=mssql_query("SELECT * from <tablename>",$con); print mssql_result($rs,0,0); mssql_close($con);' I get the output I expect. If I run this through the webserver: <html><body> <?php $con= mssql_connect("<mydb>","<uid>","<pwd>"); mssql_select_db("<dbname>",$con); $rs=mssql_query("SELECT * from <tablename>",$con); print mssql_result($rs,0,0); mssql_close($con); ?> </body></html> The only output I receive is "<html><body>" No error logs are generated anywhere (webserver, php, or freetds), even though php and freetds logging is enabled. Other php scripts that dont use the mssql functions run fine. It seems to fail at the first mssql_ function and no processing continues after that. If anyone has an idea or a way to verify if the ext/mssql module is compiled into the libphp4.so object, I would apprecate it. Thanks, Jeffrey __________________________________ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 __________________________________ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php