C
cAkk
Unregistered / Unconfirmed
GUEST, unregistred user!
Project dce.exe raised exception class EODBCError with message
'ODBC32 error ODBC32 error HY000: [Microsoft][ODBC SQL Server
Driver]Connection is busy with results for another hstmt
: [Microsoft][ODBC SQL Server Driver]Connection is busy with
results for another hstmt
'. Process stopped. Use Step or Run to continue.
使用ODBC98连接Sql Server 7.0数据库,执行以下操作时发生上面的错误:
tqen:=todbcquery.Create(nil);
tqen.database:=ODBC1;
tqen.sql.clear;
tqen.SQL.add('UPDATE dce_account SET aname=:an WHERE ano=:ao');
tqen.Prepare;
tqe0:=todbcquery.Create(nil);
tqe0.database:=odbc1;
tqe0.sql.clear;
tqe0.SQL.add('INSERT INTO dce_account (ano,aname) VALUES ao,:an)');
tqe0.Prepare;
tqe1:=todbcquery.Create(nil);
tqe1.database:=odbc1;
tqe1.sql.clear;
tqe1.SQL.add('SELECT ano,aname FROM dce_account WHERE ano=:ao');
tqe1.Prepare; //开始出错
多谢!!
'ODBC32 error ODBC32 error HY000: [Microsoft][ODBC SQL Server
Driver]Connection is busy with results for another hstmt
: [Microsoft][ODBC SQL Server Driver]Connection is busy with
results for another hstmt
'. Process stopped. Use Step or Run to continue.
使用ODBC98连接Sql Server 7.0数据库,执行以下操作时发生上面的错误:
tqen:=todbcquery.Create(nil);
tqen.database:=ODBC1;
tqen.sql.clear;
tqen.SQL.add('UPDATE dce_account SET aname=:an WHERE ano=:ao');
tqen.Prepare;
tqe0:=todbcquery.Create(nil);
tqe0.database:=odbc1;
tqe0.sql.clear;
tqe0.SQL.add('INSERT INTO dce_account (ano,aname) VALUES ao,:an)');
tqe0.Prepare;
tqe1:=todbcquery.Create(nil);
tqe1.database:=odbc1;
tqe1.sql.clear;
tqe1.SQL.add('SELECT ano,aname FROM dce_account WHERE ano=:ao');
tqe1.Prepare; //开始出错
多谢!!