Skip to Content.
Sympa Menu

freetds - Re: [freetds] another strange thing with sp's

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] another strange thing with sp's
  • Date: Thu, 12 Apr 2007 11:59:49 +0200

>
> 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





Archive powered by MHonArc 2.6.24.

Top of Page