Microsoft KB Archive/196374

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

Article ID: 196374

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft ActiveX Data Objects 1.0
 * Microsoft ActiveX Data Objects 1.5
 * Microsoft ActiveX Data Objects 2.0
 * Microsoft ActiveX Data Objects 2.1 Service Pack 2

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.