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: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS, PHP and multiple instances
  • Date: 12 Mar 2003 09:31:02 +0100

Il mer, 2003-03-12 alle 07:43, wettengel, kay ha scritto:
> 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?
>
> $dbi = mssql_connect($dbhost, $dbuser, $dbpass);
> mssql_select_db($dbbank);
> $sql = "some sql-query";
> $res = mssql_query($sql);
> mssql_close($dbi);
>
> Thank you for any help!
> Sincerely
> Kay

FreeTDS do not still support mssql2k multiple instance, however every
instance is associated to a different port. I don't remember correct
syntax but "server,port" or "server:port" should work.

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page