FreeTDS and SQL Server 7

From: Date: Tue, 16 Oct 2001 15:18:55 +0000
Subject: FreeTDS and SQL Server 7
Groups: php.general 
Request: Send a blank email to php-general+get-71225@lists.php.net to get a copy of this message
Hey all, I was reading an old article at php builder about conntecting to SQL Server 7 on a Windows machine from a Linux machine via FreeTDS. (http://www.phpbuilder.com/columns/alberto20000919.php3) Between that article and the documentation(www.freetds.org), I tried installing FreeTDS, Apache and PHP. It all compiled and runs fine, but whenever I actually try to connect to the SQL Server 7 database the Apache child seg faults. Has anyone had sucees in getting this to work? I will include my config and compile commands below as well as the php script that is breaking things. Thanks in advance for any help!!! FREE TDS 0.52 ./configure --prefix=/usr/local/freetds --with-tdsver=7.0 --enable-mdblib gmake make install APACHE 1.3.14 ./configure --prefix=/usr/local/apache_test PHP 4.0.6 ./configure --with-mysql --with-apache=../apache_1.3.14 --enable-track-vars --with-sybase=/usr/local/freetds --with-config-file-path=/usr/local/apache_test/conf make make install APACHE 1.3.14 ./configure --prefix=/usr/local/apache_test --activate-module=src/modules/php4/libphp4.a make make install PHP Script putenv("TDSDUMP=/usr/local/apache_test/logs/tds.log"); putenv("SYBASE=/usr/local/freetds"); putenv("TDSVER=70"); $nDBConn = mssql_connect("mmg", "username", "password"); echo "ConnectID: $DB<br>\n"; $nStmt = mssql_query("select * from david_test", $nDBConn); while ($aRow = mssql_fetch_array($nStmt)) { echo $aRow["Name"]; echo "<p>\n"; } mssql_close($nDBConn); David Derr davidderr@britsys.net -- ls

« previous php.general (#71225) next »