FreeTDS Development Group

["Gonzalez, Zara E" <gonzalze AT mail.slh.wisc.edu>]

I just downloaded freetds-0.53rc2 and installed it using the following 
configure
options:

./configure --with-tdsver=4.2 --enable-msdblib --enable-dbmfix --with-gnu-ld
--enable-shared --enable-static

(I just noticed I have the --with-tdsver=4.2 but I'm actually using 7.0..but I
don't think that matters in my current problem since I can still get it to 
work
with MSSQL 7.0)

I then reconfigured php-4.1.0 using the following options:

./configure --prefix=/usr/local/php --with-apxs --enable-track-vars
--enable-trans-sid --enable-trans-id --with-sybase=/usr/local/freetds
--with-mssql=/usr/local/freetds

(not sure if I need both --with-sybase & --with-mssql but again it works with
MSSQL 7.0)

Reconfigured my freetds.conf file the entries look as follows: (with x's
replaced by ip#'s of course)

[testms2000]
        host = x.x.x.x
        port = 1433
        tds version = 7.0

[testms7]
        host = x.x.x.x
        port = 1433
        tds version = 7.0

Then I restarted apache (version 1.3.22).

Tested out my connection to a MSSQL 7 server. Worked great.

Tested out my connection to my MSSQL 2000 server (running Win2k). Nothing. I
just get "Page cannot be displayed"

Now my test code is exactly the same for both the MSSQL 7 & the MSSQL 2000
servers (with the exception of the dbname, password, IP, etc). It works fine 
for
MSSQL 7, not for MSSQL 2000.

The code I am using to test is as follows: (I've tried with and without the 
path
statements commented)

<?
#putenv("SYBASE=/usr/local/freetds");
#putenv("TDSVER=70");
#putenv("LD_LIBRARY_PATH=$SYBASE/lib");

$username = "xxxx";
$password = "xxxx";
$hostname = "x.x.x.x";
$dbName = "testdb";

MSSQL_CONNECT("$hostname",$username,$password) or DIE("Error: DB not
responding.");
MSSQL_SELECT_DB($dbName) or DIE("Error: DB unavailable");

$query = "SELECT * FROM test";

$result = MSSQL_QUERY($query);

$number = MSSQL_NUM_ROWS($result);

echo $number;

?>

Am I missing something simple here?

Thanks for any help,

Zara

-----Original Message-----
From: Brian Bruns [mailto:camber AT ais.org] 
Sent: Friday, December 21, 2001 1:49 PM
To: TDS Development Group
Subject: [freetds] Re: FreeTDS & MS SQL 2000.


There was a bug in using freetds with SQL 2000 until 0.53pre1 (i think).  
Try a newer release (such as 0.53 just released today) and let men know if 
you still see the problem.

Brian