[asterisk-dev] Connection Pooling

[Greg Boehnlein]

On Mon, 23 Oct 2006, Tilghman Lesher wrote:

> On Thursday 19 October 2006 02:22, Alexandr Olekhnovich wrote:
> > I'm using asterisk => uniODBC (FreeTDS driver) => MS SQL. So I have
> > to make odbc connection pooling to MS SQL.
> 
> Since you're using MS SQL, by and large, you'll need to use 1.4 res_odbc
> to combat the problems inherent in the TDS protocol.  See the sample
> configuration file in 1.4 for more information.  If you do not use the
> facilities provided in 1.4, you will have severe problems any time you
> attempt more than one concurrent query.

Tilghman,
	Blitzrage and I were discussing func_odbc, and we were wondering 
where the best place to build failover into the system might be. We 
figured it could done at several places:

1. In the DialPlan w/ func_odbc itself
2. At the ODBC level
3. At a Layer 3/4 load balancer level
4. At the Database Server itself (clustering etc..)

Any thoughts?

P.S. Yes.. the beer is cold!

-- 
    Vice President of N2Net, a New Age Consulting Service, Inc. Company
         http://www.n2net.net Where everything clicks into place!
                             KP-216-121-ST