MS SQL Server ODBC - SQL server driver problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL server driver problem

Diana M

2006-01-04, 1:23 pm

Hello everybody,
I have stored procedure(vb6,sql server 2000(3))., that I call from VB using
odbc drivers.
This stored procedure has 10 queries and it runs without problem until 4th
query and then it exits without any reason and without errors. I do not see
any erros in sql server profiler either. VB does not give any errors either.
SP does not have output parameters and no return parameter explicitly
defined in VB.
Now if I change definition of the stored procedure (still using ODBC driver)
if I add return parameter OR if I add output parameter (to the sp and to vb),
the stored procedure will be executed until end
Also if I change ODBC driver to OLEDB driver, the sp will be executed until
end in any case (without any output or return parameter defined)
Can somebody explain this behaviour please
Thanks
Diana M

Sponsored Links