|
|
Posted by Erland Sommarskog on 07/02/07 22:09
Ben (pillars4@sbcglobal.net) writes:
> I am trying to dynamically modify my pass-through query containing a
> procedure call with 2 parameters.
>
> When I run my access app, I get this error: "Object or provider is not
> capable of performing reuqested operation."
ADOX is nothing I have experience of, but I found in MSDN under the Command
property in ADOX that it says:
An error will occur when getting and setting this property if the
provider does not support persisting commands.
Which provider are you using? How does your connection string look like?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|