Skip to Content.
Sympa Menu

freetds - Re: FreeTDS 0.52 MSSQL connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS 0.52 MSSQL connection problem
  • Date: Tue, 24 Jul 2001 07:21:26 -0400 (EDT)


Well, it definately should not be caching. Please try a recent CVS
snapshot as there were some bugs in the interfaces file stuff with 0.52.

For those interested, some of the code was moved and getservbyname() was
unitentially called before all the values from gethostbyname() were copied
off, and since the socket stuff uses a static are to return these values,
it worked on some machine and not others...

Brian

On Tue, 24 Jul 2001, Ryan D. Hatch wrote:

> I am running RH 7.1 with Apache 1.3.20, PHP 4.0.6, and FreeTDS 0.52 and
> I have compiled with the following configure command;
>
>
> ./configure --prefix=/opt/freetds-.052 --with-tdsver=4.2
>
>
> I have an interfaces file that looks like this,
>
> #
> JDBC
> query tcp tds5.0 192.138.151.39 4444
> master tcp tds5.0 192.138.151.39 4444
> myserver
> query tcp ether 127.0.0.1 4000
> master tcp ether 127.0.0.1 4000
>
> baer-test
> query tcp tds4.2 10.0.0.24 1433
> baer
> query tcp tds4.2 10.0.0.24 1433
> anyway, here is the problem i am having. when I try to connect to baer
> with tds (using php with mssql_pconnect("baer", "sa", "password")), i am
> unable to do so. However, when I try from a Windows box (connecting to
> that database with the same info), it works just fine. Also, when I try
> with my old version of tds .51 on another box, it too also works....
>
> but it gets better.
>
> It appears that it is caching some tds connection information. When
> specify "baer-test", it does work. When I change the interfaces file to
> reflect a different IP for baer-test, it continues to send login
> information, data, etc. to the old IP of baer-test. Even when I restart
> apache i am having this problem.
>
> Any ideas?
>
>
> Thanks in advance,
>
> Ryan
> ÿÿØ¢æ«yË«­éí—+.nÇ+‰·¶‡ëyë]±«ÿýƦmêÿj+ÿ¢¸ÿN‹§²æìr¸›{÷诫vØb²g¬±¨¶‰^j÷ÿ~·žµÛÿ×m½àÏß­©ä–)ÿ¢+ÿºwÿ
>





Archive powered by MHonArc 2.6.24.

Top of Page