Error, are not allowed to start new things, because there are other threads are running in the session,

These days with PB development projects, use alternative query, the same statement on sqlserver2008 perform no problem in it,
But the use of PB execution is an error, I do a button when debugging, the SQL error was obtained from the local text, perform discovery have this error,
Has the following several ways:
1, the isnull (' XXXX ', ') & lt;> 'where are changed to XXXX is not null and XXXX & lt;> 'and carried out;
2, changing the position of the small statements, and can perform the
3, the parameters in the where clause for the where (InventoryClass cinvcname like '% seafood %') is not an error,
To the where (InventoryClass cinvcname like '% % class') and error, I was dumbfounded,

Everyone a great god have met this strange situation, have a solution? Urgent urgent

CodePudding user response:

Supplement, while on a track part parameters of this transaction are as follows:
Sqlcode=1
Sqldbcode=3988
Sqlerrtext="are not allowed to start a new transaction, because there are other threads are running in the session,"
The DBMS="MSS Microsoft SQL Server 6. X"

CodePudding user response:

Haven't met, but can say in the SQL language can perform, but really can not necessarily in the PB,

CodePudding user response:

Use the OLEDB interface or ODBC interface?

CodePudding user response:

Advice from the new compiler under 1