[freetds] Different Sybase DB servers with same dataserver name
nitram29 at hotmail.com
Wed Apr 1 03:46:45 EDT 2009
> 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
>> host = foo
>> port = 43443
>> tds version = 5.0
>> ; 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.
Unfortunately it does not.  (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?
Unbegrenzter Speicher bei Windows Live Hotmail!
More information about the FreeTDS