Skip to Content.
Sympa Menu

freetds - Re: [freetds] Different Sybase DB servers with same dataserver name

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: foo bar <nitram29 AT hotmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Different Sybase DB servers with same dataserver name
  • Date: Wed, 1 Apr 2009 09:46:45 +0200




----------------------------------------
> Date: Tue, 31 Mar 2009 10:56:02 -0400
> From: jklowden AT freetds.org
> To: freetds AT lists.ibiblio.org
> Subject: Re: [freetds] Different Sybase DB servers with same dataserver name
>
> foo bar wrote:
>> * my applications needs to access both databases but cannot beacuse both
>> have the same dataserver
>>
>>
>> freetds.conf
>>
>> [dbA]
>> host = foo
>> port = 43443
>> tds version = 5.0
>>
>> ;[dbA]
>> ; host = bar
>> ; port = 43443
>> ; tds version = 5.0
>>
>>
>>... I want to be able to connect to both databases at the same time.
>
> The dataserver name is your local choice. It is the name you assign to
> the combined properties of the server: host, port, and TDS version.
>
> To connect to a server, you need a dataserver name. To connect to two
> servers, you need two dataserver names.
>
> HTH.

Unfortunately it does not. [1] (at the very bottom) says that Sybase SQL is
fussy. I have to use the database names as datasever names. Since the
database names on both machines are equal it is not possible to connect to
both, is it?

Thank you.



[1] http://www.freetds.org/userguide/freetdsconf.htm#FTN.AEN843

_________________________________________________________________
http://redirect.gimas.net/?n=M0904xWLHM2
Unbegrenzter Speicher bei Windows Live Hotmail!



Archive powered by MHonArc 2.6.24.

Top of Page