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


The information in this article applies to:

  • ActiveX Data Objects (ADO) 1.0
  • ActiveX Data Objects (ADO) 1.5
  • ActiveX Data Objects (ADO) 2.0
  • ActiveX Data Objects (ADO) 2.1 SP2
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.
Modification Type:MinorLast Reviewed:3/2/2005
Keywords:kbMDACNoSweep kbprb KB196374
©2004 Microsoft Corporation. All rights reserved.