This is a discussion on Two resultsets in the same hstmt - ADO DAO RDO RDS ; Fellows, I am having in a big trouble using two resultsets that are opened in the same time by the same connection. The error code is: Portuguese Run-time error '40002': S1000: [Microsoft][ODBC SQL Server Driver]Conexão ocupada com resultados de outro ...
Fellows,
I am having in a big trouble using two resultsets that are opened in the
same time by the same connection.
The error code is:
Portuguese
Run-time error '40002':
S1000: [Microsoft][ODBC SQL Server Driver]Conexão ocupada com resultados de
outro hstmt
English:
Run-time error '40002':
S1000: [Microsoft][ODBC SQL Server Driver]The connection is busy with
results from an other hstmt
The driver used to connect to the server is:
rdUserClientBatch
Is there any way to use this cursor and open these two resultsets at the
same time?
Is there any way I can open a second resultset without open a second
connection to the database?
Observation:
Data Base: SQL Server 6.5
Server Operating System: Windows NT 4.0
Workstation Operating System: Win98
Developing in: Visual Basic 4.0
Thanks for now,
Andre