SQL Server ODBC: "Connection is busy with results for another command" error

[Dave Rabelink]

"Connection is busy with results for another command" error in a specific scenario when using SQL Server ODBC 17 driver.

Applies to
Gupta Team Developer (TD) 6.3, 7.0, 7.1, 7.2

Summary
In Gupta Team Developer (TD), when using SQL Server ODBC 17 driver, you may receive the error "Connection is busy with results for another command" error in a specific scenario, highlighted in the code below:

SQLS_ERROR.jpg

Resolution
Make sure you enable SQL Server Multiple Active Result Sets (MARS) in your SQL.INI ODBC section as shown below:

Code: Select all

[odbcrtr]
MARS=1

[Steve Leighton]

.
If you are using OLE DB , rather than ODBC, you may still get the same issue, in which case you can enable MARS via your connection string ( or udl file ) with the following:
.

MARS for OLEDB.JPG

[EwaldP]

Hi,

I struggle with some ODBC/UDL connection problems with TD 7.3 and SqlServer. Main problems are:

1. Connect UDL works when I use an udl file but don't work when I try to connect with a connection string.

2. If I connect with ODBC I get the above described error (20055). mars=1 is in the sql.ini

2021-01-26 17_07_13-OpenText Team Developer (Win32) 7.3 [Run] - wawi.app - [wawi.app].png

My Sql.ini

[odbcrtr]
;enablemultipleconnections=1
MARS=1
REMOTEDBNAME=ENTS4,Driver=SQL Server;Server=edvhaus-sql01\sqlexpress;Database=ENTS4;Ansinull=No;AnsiNPW=No;QuotedId=Yes;AutoTranslate=No;Language=German

odbctrace=off
;odbctracefile=sql.log
;longbuffer=2500000

3. Installation Microsoft ODBC Driver 17
TD is installed on a Win10 Pro machine. MS ODBC Driver 17 for SQL Server is installed. If I want to reinstall the x86 msi, I get an error that the driver can't be installed due the operating system is to old?

Any suggestions?

Thanks
Ewald

[a_sivababu]

Hi Ewald,
there is nothing more as you have already created ODBC and set MARS=1 in sql.ini. Have you double checked for right sql.ini and deleting Gupta.ini.

Just note - I have replaced my quite standard SQL Server Driver with MS Sql Server 17 a month back for Cloud. it is really super fast.

Thanks
Siva A

[Mirko]

Dave, Steve,

How could the world turn round without your help, guys ???

Thanks for this ready-to-use solution

Mirko