Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

Thanks for the tips.
I setup the variable "TDSDUMPCONFIG=/tmp/tds_con.txt" to track the
procedure.
inside the text file:
Starting log file with debug level 99.
2003-02-07 16:26:20.257089 Attempting to read conf files.
2003-02-07 16:26:20.257243 ...$FREETDSCONF not set. Trying $HOME.
2003-02-07 16:26:20.257613 Found conf file '/usr/local/etc/freetds.conf'
(default). Reading section 'ms'.
2003-02-07 16:26:20.257721 Looking for section global.
2003-02-07 16:26:20.257891 ... Found section global.


So we can see the tds is using the "ms" to find a match in freetds.conf. It
supposed to use "mssql7" to find a match in freetds.conf. What happened?


-----Original Message-----
From: freetds-admin AT lists.ibiblio.org
[mailto:freetds-admin AT lists.ibiblio.org]On Behalf Of Jun Jian
Sent: Friday, February 07, 2003 2:05 PM
To: freetds AT lists.ibiblio.org
Subject: RE: [freetds] Problem of connection to MSSQL7 from
freetds0.61/php-4.1.2


I alos use php with mysql, there is no such problems. Just change the code
mssql_connect()
to mysql_connect(), it works very well.
so the problem may not be the php problem.
Hope more tips.

Thanks.

-----Original Message-----
From: freetds-admin AT lists.ibiblio.org
[mailto:freetds-admin AT lists.ibiblio.org]On Behalf Of Lowden, James K
Sent: Friday, February 07, 2003 12:08 PM
To: 'freetds AT lists.ibiblio.org'
Subject: RE: [freetds] Problem of connection to MSSQL7 from
freetds0.61/php-4.1.2


From: Jun Jian [mailto:jun.jian AT canarie.ca]
Sent: February 7, 2003 11:40 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Problem of connection to MSSQL7 from
freetds0.61/php-4.1.2


"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. "


BTW, "--enable-dbmfix" no longer has any effect, per ChangeLog 7 November
2001.


"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 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?"


Oh, dear. I sure looks like a PHP problem, like someone changed fixed
buffers to char*, but didn't change the sizeof(). I'm sure we're not
truncating them on input.

Can anyone reproduce Jun's problem? I bet a breakpoint on the call to
dbopen() would help track it down.

--jkl

P.S. It is better not to send HTML mail to mailing lists. :-)


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page