increase database connections

[TangoRules]

Hi all,

Currently, I notice that there are only two database connections between my
ColdFusion server and the SQL server. May I ask how can I increase the amount
of database connections?

Thanks in advance,
Monte

[TSB]

Hi Monte,

You can change your DB connection settings from the advance settings when you edit a cf datasource.

T

[TangoRules]

Are you referring to Limit Connections settings? Currently, that check box is not checked. So, I would assume thatit is set to unlimited concurrent connections??

[cgsj_usa@yahoo.com]

I have installed CFMX 7 on a Windows 2003 SP1 machine and I am seeing just the
opposite. I am connecting to SQL Server via an ODBC connection on the CF
server. Connection pooling is enabled and in the CFAdmin page, limit
connection to 5 is checked. Maintain connections is also checked and a timeout
of 1 min and an interval of 1 min are set. The problem that I am having is
excessive connections between the CF machine and the SQL Server...way in excess
of the 5 connections specified. Anyone have any idea of what's going on?
Thanks.

Chris