Skip to Content.
Sympa Menu

freetds - Re: [freetds] Multiple Connection Pools

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <brian.bruns AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Multiple Connection Pools
  • Date: Mon, 9 May 2005 11:56:43 -0400

A connection pool can query multiple databases on one server just like
you would without the connection pool, use the dbname..tablename
notation.

The database name in the pool.conf file is the database which the
connection will "use" upon first connection. You should not do things
like "use database2" when running through the pool or things will go
horribly wrong. I have a way to fix this but currently lack the time
to do it.

On 5/9/05, Shaun Craig <s.craig AT andronics.com> wrote:
> Can a connection pool query multiple databases? If so how do you set
> this up in pool.conf, as I know it you have to give a database name in
> this file, how can you add more databases?
>
> Shaun.
>
> Shaun Craig wrote:
>
> > Hi
> >
> > Is it possible to have multiple connection pools running and if so do
> > you leave them on port 5000 or do you have to split them up?
> >
> > Is there any dangers with multiple connection pools, etc, any info
> > would be great
> >
> > Thanks,
> > Shaun.
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page