
Please help!!!ADO connection object problem
Hi All,
I am facing problem with connection object.
Here is my code sample
dim conninfo as new adodb.connection
conninfo.open connectionstring
its fine now ,connection opened.
Then i am executing a stored procedure and assign to
recordset object,like follows.
set rsr =conninfo.execute "SP_NAME x,y"
I did not mentioned any cursor location.
Problem here is , When i execute the stored procedure
in a loop with various parameter values,after
approximatly 100 times, it is not executing stored
procedure properly,some statements in stored procedure was
not executed. Why it is happening.
but when i run in debug mode it is executing properly.
Do you why this strange thing happening. Please Help me.
Waiting for reply very eagerly.I am using sybase
database.
Thanks
suresh