[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