Biztalk 2004 & SQL

I have some questions about how to determine if my Biztalk 2004 is using
connection pooling or not. Also, I would like to determine if the Microsoft
Biztalk 2004 application uses OLE DB, or ODBC for its connection to SQL
Server 2000.
Also, how can I trace the info or statistics?
Thanks for any suggestions!Hi
SQL Profiler will give you this, if this is not in the SQL Server program
group you can find it in the Tools\Binn\profiler.exe. Check for different
commands on the same SPID from different users.
John
"Johnson" wrote:

> I have some questions about how to determine if my Biztalk 2004 is using
> connection pooling or not. Also, I would like to determine if the Microso
ft
> Biztalk 2004 application uses OLE DB, or ODBC for its connection to SQL
> Server 2000.
> Also, how can I trace the info or statistics?
> Thanks for any suggestions!
>
>