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: Fri, 3 Apr 2009 10:19:34 +0200




----------------------------------------
> Date: Fri, 3 Apr 2009 09:52:39 +0200
> From: freddy77 AT gmail.com
> To: freetds AT lists.ibiblio.org
> Subject: Re: [freetds] Different Sybase DB servers with same dataserver name
>
> 2009/4/1 foo bar
>>
>>
>>
>> ----------------------------------------
>>> 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.
>>
>
> There is an "asa database" option. Is not available in 0.82 but in CVS
> HEAD (or a snapshot).
> Please try the option, if works I'll backport it.

Using the snapshot it works. As far as I can see this new option is mandatory
because I can not connect to any ASA DB without specifying it.

Thank you very much.

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



Archive powered by MHonArc 2.6.24.

Top of Page