FreeTDS and SQL Server 7
| From: | David Derr | 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