[freetds] another strange thing with sp's
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Thu Apr 12 05:59:49 EDT 2007
>
> People, there is another strange thing with stored procedure
> call. If I build the statement like "{ call sp_myproc(?) }",
> do not work. But if I build statement like "{ call
> [owner].[sp_myproc] (?) }", then work. I have to put onwer!!
>
> Is this correct?
>
> In that case, diagnostic is not returned.
>
> I'm connecting in SQLServer...
>
This should be related to mssql, not to FreeTDS. It seems that if the
store is created not by dbo you have to specify the owner. Don't ask me
why... perhaps it also work if the user you are using is the same who
create the store...
freddy77
More information about the FreeTDS
mailing list