FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Wed, 12 Mar 2003 07:43:01 +0100, "wettengel, kay"
<kay.wettengel AT stahl.de> wrote:
> Hallo!
> Since a few weeks I've just compiled the FreeTDS-Support into the
> php-module on my linux-server. And it is very easy to contact a simple
> MS SQL-Server now.
> But as a matter of fact we do have more than one SQL-Server. The latest
> is a MS SQL-Enterprise Server with more than one instance of MS
> SQL-Server insalled. Did any of you have that problem before?
> How can I tell php which instance to connect to?

Just make an entry for each name in freetds.conf:

[name1]
        host = server.domain.com
        port = 1400
[name2]
        host = server.domain.com
        port = 1401

FreeTDS looks up servernames.  It doesn't mind that several entries point
to the same machine.  

--jkl