freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Problem of connection to MSSQL7 from freetds0.61/php-4.1.2

From: "Jun Jian" <jun.jian AT canarie.ca>
To: <freetds AT lists.ibiblio.org>
Subject: [freetds] Problem of connection to MSSQL7 from freetds0.61/php-4.1.2
Date: Fri, 7 Feb 2003 11:39:49 -0500

I have compiled freetds0.61 with " --with-tdsver=4.2 --enable-msdblib --enable-dbmfix --with-gnu-ld --enable-shared --enable-static " and installed on my Redhat 7.0 at /usr/local/freetds.

I tested it with tsql, it worked well.

Than I recompiled and reinstalled php-4.1.2 with "--with-sybase-ct=/usr/loca/freetds", restart apache-1.3.23,

I got a problem described as follow:

the php code is:

<?php

putenv("TDSDUMP=/tmp/tds.log");
putenv("TDSDUMPCONFIG=/tmp/tds_con.txt");
putenv("SYBASE=/usr/local/freetds");
putenv("TDSVER=7.0");

$numero= mssql_connect("mssql7 ", "name ", "password ");

echo ("ConnectID: $numero<br>\n");

mssql_close($numero);

I got the result "Warning: Sybase: Unable to connect in /var/www/html/test/test1.php on line 8 "

and I took a loot into tds.log and tds_con.txt, I fond that the server name become to "ms", username was"na", pass word was"pa".

It seemed that the string got truncated, does anyone has such problem before?

By the way, I use freetds.conf as configuration file fro freetds. the mssql server is MSSQL7.0 on Win NT.

Any help?

[freetds] Problem of connection to MSSQL7 from freetds0.61/php-4.1.2, Jun Jian, 02/07/2003