Skip to Content.
Sympa Menu

freetds - Re: FreeTDS & MS SQL 2000.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Gonzalez, Zara E" <gonzalze AT mail.slh.wisc.edu>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS & MS SQL 2000.
  • Date: Fri, 21 Dec 2001 15:03:01 -0600


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





Archive powered by MHonArc 2.6.24.

Top of Page