[freetds] SQLExecDirect() of transaction statement returns SQL_NO_DATA

Sebastien FLAESCH sf at 4js.com
Tue Jan 8 07:55:24 EST 2008


Is it expected that an SQLExecDirect("BEGIN TRANSACTION") returns SQL_NO_DATA (100) ?

I would maybe expect SQL_SUCCESS_WITH_INFO, but not SQL_NO_DATA ...

Attached, a sample to reproduce, give me this output:

 >> SQLExecDirect return code = 100 for [BEGIN TRANSACTION]
 >> SQLExecDirect return code = 100 for [COMMIT TRANSACTION]
 >> SQLExecDirect return code = 100 for [BEGIN TRANSACTION]
 >> SQLExecDirect return code = 100 for [ROLLBACK TRANSACTION]
 >> SQLExecDirect return code = 100 for [SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED]
 >> SQLExecDirect return code = 100 for [SET TRANSACTION ISOLATION LEVEL READ COMMITTED]
 >> SQLExecDirect return code = 100 for [SET TRANSACTION ISOLATION LEVEL REPEATABLE READ]
 >> SQLExecDirect return code = 100 for [SET TRANSACTION ISOLATION LEVEL SERIALIZABLE]

Seb
-------------- next part --------------
A non-text attachment was scrubbed...
Name: odbctest1.c
Type: text/x-csrc
Size: 4248 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080108/43ba6f34/attachment.bin 


More information about the FreeTDS mailing list