freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Re: connecting to remote MS Sql 2k server from linux PHP

From: "James K. Lowden" <jklowden AT schemamania.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Re: connecting to remote MS Sql 2k server from linux PHP
Date: Fri, 29 Oct 2004 00:30:46 -0400

Daniel Fazekas <fdsubs AT axelero.hu> wrote:

Hi Daniel,

> On Oct 28, 2004, at 18:31, Rick D. Conner wrote:
>
> Further weirdness: according to the log, FreeTDS seems to find the
> myserver2k entry in /home/bwelch/.freetds.conf anyway - but it ignores
> it and doesn't seem to be looking for it, instead trying to find the
> default SYBASE entry.

That's what puzzles me. It would mean that mssql_connect failed to pass
"MyServer2k" to dbopen(). The library then proceeds to attempt a
connection to the default database, named "SYBASE". Maybe a PHP log would
tell us something.

> Then, despite all this, at the end it tries to connect to the mssql
> default port 1433 even though the default should be sybase's port 5000

I bet --with-tdsver=7.0.

--jkl

[freetds] connecting to remote MS Sql 2k server from linux PHP, Rick D. Conner, 10/28/2004
- [freetds] Re: connecting to remote MS Sql 2k server from linux PHP, Daniel Fazekas, 10/28/2004
  - RE: [freetds] Re: connecting to remote MS Sql 2k server from linux PHP, Rick D. Conner, 10/29/2004
  - Re: [freetds] Re: connecting to remote MS Sql 2k server from linux PHP, James K. Lowden, 10/29/2004