To use Microsoft OLE DB Driver for SQl Server (MSOLEDBSQL) to establish database connection.

Question

To use Microsoft OLE DB Driver for SQl Server (MSOLEDBSQL) to establish database connection.

Sankaranarayanan M 1

Currently, We using Visual Basic 6.0

For Database connection, we are using ADODB connectivity through the "SQL Server Native Client 11.0" Driver

We want to replace "SQL Server Native Client 11.0" Driver with "Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)"

What is format for the connection string and Driver name for ADODB connectivity to be used for the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) in Visual Basic 6.0 ?

if possible can give an example for connection string.

Sankaranarayanan M 1 Reputation point

2022-07-28T09:40:52.283+00:00

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?

1 answer

Your answer

Sankaranarayanan M 1 Reputation point

2022-07-28T09:40:52.283+00:00

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?

Answer 1

Castorix31 90,686

You can check connection strings at Microsoft OLE DB Driver for SQL Server connection strings

Sankaranarayanan M 1 Reputation point

2022-07-29T04:33:33.16+00:00

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?

Share via

To use Microsoft OLE DB Driver for SQl Server (MSOLEDBSQL) to establish database connection.

1 answer

Your answer