Skip to Content.
Sympa Menu

freetds - Re: Two databases, same name, different IPs?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Two databases, same name, different IPs?
  • Date: Wed, 28 Nov 2001 17:34:25 -0500 (EST)


James,

The servername of the dataserver (what is returned by 'select
@@servername') does not have to be faithfully reproduced on the freetds
client machine. Any name will do, by convention it's often easier to keep
straight if they match, but there is no requirement to do so.

Brian

On Thu, 29 Nov 2001, James Cameron wrote:

> Just struck an oddity.
>
> We have just grabbed a copy of our production database, stuck it on
> another box, with a new IP address, and I cannot figure out how to tell
> the freetds.conf file or interfaces how to connect to the different IP
> address and yet use the same database name.
>
> Or am I just really confused?
>
> I'm getting a failure to connect, but I haven't done a dump yet.
> Will do it.
>
>





Archive powered by MHonArc 2.6.24.

Top of Page