[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] another strange thing with sp's
From:       "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio () vodafone ! com>
Date:       2007-04-12 9:59:49
Message-ID: F7F148C986A2A84F930FEB8C3B169EA002FBCCF4 () OPDMEXO01 ! omnitel ! it
[Download RAW message or body]

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

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]