For automatic transactions and SQL Passthrough, use SQLSETPROP() as in:

=SQLSETPROP(nConnectionHandle,"Transactions",1) === Auto on
=SQLSETPROP(nConnectionHandle,"Transactions",2) === Auto off, use SQLCOMMIT()

There is no blind rule for an optimal ODBC connection. Generally, you want to play around with buffer and packet sizes until it runs well :-)


>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.