in windows 8 on not working properly about odbc HOT 6 CLOSED

Please, build small program to demonstrate, Something I can reproduce here. 
Would be nice if you follow this:

>>
What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.
>>

Thank you.

Alex

the example please see the file

I will try it. Thank you.

Alex

Zuggie.Zhu,

I just added new TestMSSQLExecStoredProcedure 
https://codereview.appspot.com/106030043 to demonstrate how to call stored 
procedure. I think it should cover your scenario. I'm closing this issue. 
Please, let me know, if you think there is more to your problem. Thank you.

Alex

alex,I found the root cause, I write the store procedure like this:

begin try
 begin tran
 ......
 end tran
end try
begin catch
 rollback tran
end catch

when I use program call it,it can't run,so I modify it like this:

begin tran
 ......
 if @@error<>0
 begin
    rollback tran
 end
 commit tran
end tran

now it can running.

Glad you have found your problem.

Alex