Re: Different Sybase DB servers with same dataserver name
foo bar <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
---------------------------------------- > Date: Tue, 31 Mar 2009 10:56:02 -0400 > From: [email protected] > To: [email protected] > 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!