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

General discussion forum about all databases other than SqlBase.
Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 3145
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

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

Post by Dave Rabelink » 03 Oct 2019, 06:07

"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
You do not have the required permissions to view the files attached to this post.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 274
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

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

Post by Steve Leighton » 16 Feb 2020, 20:41

.
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
You do not have the required permissions to view the files attached to this post.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

EwaldP
Austria
Posts: 339
Joined: 07 Mar 2017, 08:00
Location: Austria

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

Post by EwaldP » 26 Jan 2021, 16:17

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
You do not have the required permissions to view the files attached to this post.
Ewald P. Palmetshofer
EDV-Hausleitner GmbH
4020 Linz
www.edv-hausleitner.at

a_sivababu
India
Posts: 498
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

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

Post by a_sivababu » 27 Jan 2021, 03:07

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
Italy
Posts: 1299
Joined: 04 Apr 2017, 08:56
Location: Geneva

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

Post by Mirko » 15 Mar 2021, 13:57

Dave, Steve,

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

Thanks for this ready-to-use solution

Mirko

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests