Getting error "Error 3704 operation is not allowed when the object is closed vb6" using ADODB with Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL).

Sankaranarayanan M 1

Currently, We using Visual Basic 6.0

For Database connection, we are using ADODB connectivity through the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL).

I am getting this error "Error 3704 operation is not allowed when the object is closed vb6"

In this website (https://dacosta9.wordpress.com/2017/10/13/run-time-error-3704-operation-is-not-allowed-when-the-object-is-closed/#:~:text=by%20John%20DaCosta-,Run%2Dtime%20error%20'3704'%20Operation%20is%20not%20allowed,when%20the%20object%20is%20closed&text=13%201%20Minute-,Run%2Dtime%20error%20'3704'%20Operation%20is%20not%20allowed%20when,intermediary%20%E2%80%9Crows%20affected%E2%80%9D%20messages)

They have given solution to use SET NOCOUNT ON in the stored procedure or in the SQL statement used with ADO

I have tried in one SP above mention solution is working.

Since we have multiple SP's, is there any solution other than the above mentioned one?

Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-07-29T07:11:01.223+00:00

Hi @Sankaranarayanan M ,
The Visual Basic team is committed to "It Just Works" compatibility for Visual Basic 6.0 applications on supported Windows versions.
No other support is provided for it.
It is recommended that you post your question to the forum below.
https://www.vbforums.com/forumdisplay.php?1-Visual-Basic-6-and-Earlier

Your answer