I have a server supporting a phone system of about 300 phones. When calls are made, many different connections are opened and closed during the course of a call. I'm starting to see "out of database connections" and "timeout expired messages" when making calls to the database.
The call processing software uses an ODBC DSN to connect to the database. I'm guessing that the connection pool is out for the DSN (if that's possible).
How can I check the maximum pool size? If I have to specify the maximum pool size in the connection string, is there a way I can add it with odbcad32 app (maybe in the ini files)? I see the Connection Pooling tab, but it only has the option of how long unused connections remain. These are Windows 2000 and Windows NT systems. I don't have the ability to change the code.