SQL Server ODBC Error

[manimaran]

Hi Friends,

I am using CTD 4.1 and SQL Server 2005. When i am working with my application getting the following error.

SQL Error 20055 [Microsoft][ODBC SQL Server Driver]Connection in busy with results for another hstmt.

My application through this error, when it's process multiple resultsets in loop.

Please help me to resolve this issue.

Manimaran

[Josi54]

Hi!

Set SqlResultSet = TRUE
Call SqlConnect(hSql)
Call SqlPrepareAndExecute(hSql, 'select x from y')
While SqlFetchNext(hSql, nRet)
Do some SQL-stuff


OR


Call SqlConnect(hSql)
Call SqlSetResultSet(hSql, TRUE)
Call SqlPrepareAndExecute(hSql, 'select x from y')
While SqlFetchNext(hSql, nRet)
Do some SQL-stuff


Hope this helps.

Josi45

[rjhilliard]

I resolved this by using Call SqlResultset(hsql, TRUE)

[FRBhote]

The problem with using the Native driver and setting REsult Set to TRUE is that you ned to commit each cursor individually.

[willkf25]

Code: Select all

SqlSetResultSet(hSql, TRUE)

that's worked fine for me!
I've speend to much time in this issue...

Thx a loot!