Do you have any idea why the following doesn't work?
I'm simplifying it a little bit but let's take this example.
The query itself works fine but when it tries to execute the
commitTrans
it gets an error saying it's not connected.... Does this have
to do with the DSN settings or perhaps the settings of the
connection
string?

?gnchadocn.ADOCn.ConnectionString
Provider=MSDASQL.1;Connect Timeout=15;Extended
Properties="DSN=Benchmark
Test;SERVER=TDBSRVR_SERVER_4;SYSID=CAICCI1;APPLID=TDBSRVR4;UID=BQTS3;PWD=XXX
XX;TRANSTABLE=;TABLECACHE=N;TABLELISTMASK=;AUTOCOMMIT=N";Locale
Identifier=1033

         gNCHADOCn.ADOCn.BeginTrans

         Call gNCHADOCn.ADOCn.Execute(SQL)

         gNCHADOCn.ADOCn.CommitTrans 'runtime error '-2147168242
(8004d00e)'; No Transaction is Active

I currently have my DSN as a User DSN

(again running regular queries against this DSN work fine).