I want the most optimal connect string.
What options do you developers use? Reccommend?

I specifically want to know about.
The Automatic Transactions..
How do I turn this on and off in the connect
sting.

Mine looks like:
'DRIVER=SQL Server;SERVER=RUNTIME-PDM;UID=sa;PWD=sa;APP=QuestPDM®;WSID=TJM;
DATABASE=questpdm;AutoTranslate=No;
Regional=Yes;UseProcForPrepare=2;
QuotedId=Yes;AnsiNPW=Yes;PacketSize=18192'

But I can't figure out where to look for all the options.

Thanks.