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), version 1.0

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.


Keywords          : kbADO kbSQLServ kbVisID kbVS97 kbGrpASP 
Version           : WINDOWS:1.0,97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 10, 1999