PRB: "Invalid Operation" Error When Executing Query to SQL 6.5

ID: Q196374

The information in this article applies to:

Microsoft Visual Studio 97
ActiveX Data Objects (ADO), versions 1.0, 1.5, 2.0, 2.1 SP2

SYMPTOMS

After installing the SQL 6.5 Utilities Client Configuration application and trying to create an ADO Connection and run queries against a SQL 6.5 database, you may see the following error message:

Error source adodb command 3709 - Invalid operation

NOTE: The above error message is returned by a stored procedure executed through a Command object.

CAUSE

The installation of the Client Configuration application resets the TCP/IP setting to named pipes, which then causes the ODBC datasource configurations setups to change as well. This causes a permission problem when using the Web server anonymous account to launch ADO queries against the remote SQL database.

RESOLUTION

Reconfigure the Client Utilities and ODBC settings use TCP/IP rather than Named Pipes.

STATUS

This behavior is by design.

Additional query words:

Keywords : kbADO kbDatabase kbSQLServ kbVisID kbVS97 kbGrpASP kbGrpMDAC kbDSupport kbADO210sp2
Version : WINDOWS:1.0,1.5,2.0,2.1 SP2,97
Platform : WINDOWS
Issue type : kbprb