|
|
Posted by Ben on 07/02/07 23:44
Below is the connection string:
ODBC;DSN=YES2;DATABASE=YES100SQLC;
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99621E8AFE47Yazorman@127.0.0.1...
> 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]
|