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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Different Sybase DB servers with same dataserver name
  • Date: Fri, 3 Apr 2009 09:52:39 +0200

2009/4/1 foo bar <nitram29 AT hotmail.com>
>
>
>
> ----------------------------------------
> > 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.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page