Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS, PHP and multiple instances

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS, PHP and multiple instances
  • Date: Wed, 12 Mar 2003 08:13:45 -0500

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






Archive powered by MHonArc 2.6.24.

Top of Page