Re: Different Sybase DB servers with same dataserver name
foo bar <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
---------------------------------------- > Date: Fri, 3 Apr 2009 09:52:39 +0200 > From: [email protected] > To: [email protected] > 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: [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. >> > > 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!