> There is a SP on Sybase
>
> CREATE PROC sp_test @t VARCHAR(32) = 'default string'
> AS
> SELECT @t
>
> I want execute that from SQL
>
> SELECT * FROM
> OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test')
>
> works file. But with the parameter it fails
>
> SELECT * FROM
> OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test "TEST"')
>
> Could not process object 'exec sp_test "TEST"'. The OLE DB
> provider 'MSDASQL' indicates that the object has no columns.

"Erland Sommarskog" <sommar@algonet.se> wrote in message

> > There is a SP on Sybase
> >
> > CREATE PROC sp_test @t VARCHAR(32) = 'default string'
> > AS
> > SELECT @t
> >
> > works file. But with the parameter it fails
> >
> > SELECT * FROM
> > OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test "TEST"')
> >
> > Could not process object 'exec sp_test "TEST"'. The OLE DB
> > provider 'MSDASQL' indicates that the object has no columns.
>
> On SQL Server the setting QUOTED_IDENTIFIER is on by default when you
> connect from anything by DB-Library. Sybaes has a similar setting, but
> I don't know which defaults that apply.
>
> In any case, with this setting, names in double quotes are identifiers not
> string literal. Try this instead:
>
> SELECT * FROM
> OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test ''TEST''')
>
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

> "Erland Sommarskog" <sommar@algonet.se> wrote in message
>
> No, it isn't a quotes issue. The same effect if the parameter is integer.
>
> SELECT * FROM
> OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test 1')