Knowledge Base

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

Article ID: 196374

Article Last Modified on 3/2/2005

APPLIES TO

This article was previously published under Q196374

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: error 3709

Keywords: kbprb kbmdacnosweep KB196374


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.