I have a TDatabase pointing to an MSSQL alias and all my datasets go through
the TDatabase. However, sometimes my datasets will use the connection to SQL
Server that the TDatabase opened, but other times they will create their own
connection which is not freed, therefore running out of available
connections.

I cannot find any reason for the extra connections being created.

I read a similar posting which suggested setting the SQL Passthru Mode to
SHARED NOAUTOCOMMIT, but this does not fix the problem.

Any help on preventing the new connections will be greatly appreciated.

Colin Dunn
colin.d...@enviros.com