I have an application that connects to a SQL 2005 ENT Database. The app (running on a cluster like environment) on average runs 131 concurrent connections. I notice in the app logs the following error:
Maximum count of allowed ODBC sessions are exceeded. (Current: 4, Preferred: 3) (FILE: Main.cpp LINE: 840)
RELEASED the ODBC sessions exceeding the maximum amount. (Current: 4, Preferred: 3)
Our SQL Server connections are set to "0" unlimited. Does anyone know it there is a setting somewhere in SQL or ODBC where I can increase the sessions limit?
I've searched around and found something about pooling?
Thanks so much!