I have developed a program and I use Stored Procedures.
Qt only connect to sql via ODBC and not support oledb.
When i use some some sql statement like declare , EXEC and ... my program will fail. I use the profiler and see this error :
"A server cursor cannot be opened on the given statement or statements. Use a default result set or client cursor."
The reason of this error is ODBC because ODBC dos not support cursor (only default cursor).
What should I do?
Is there a way for using OLEDB provider?
This is my simplified stored procedure :
Qt Code:
  1. declare @temp int
  2. select * from TUser u
To copy to clipboard, switch view to plain text mode 
[/Code]