It gives the result of output parameters but not the actual data result. Is it something I am doing wrong, I don't know? Can someone help me I am struggling with this from past 2 days?ĮXEC. Server "LinkedServer" indicates that either the object has no columns or the current user does not have permissions on that object. The OLE DB provider "Provider" for linked OLE DB provider "ProviderName" for linked server "LinkedServer" returned message "Must declare variable 7215, Level 17, State 1, Line 59Ĭould not execute statement on remote server 'LinkedServer'.įROM OPENQUERY(LinkedServer, 'SET FMTONLY OFF EXEC Out)Ĭannot process the object "SET FMTONLY OFF exec Out". No workĬould not execute procedure 'StoredProcedure' on remote server 'LinkedServer'.Įxec ('EXEC Out) AT LinkedServer Check each OLE DB status value, if available. OLE DB provider "ProviderName" for linked server "LinkedServer" returned message "Multiple-step OLE DB operation generated errors. I have tried different ways of Execution of stored procedure.Įxec Out But i am having issues when I execute Stored procedures which accepts like 20-25 parameters The Linked Server works as it gives required results when data is selected from tables. I am using Linked server created in SQL Server 2008 R2 to connect to Sybase db. I have checked previous threads but no use.here is my issue
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |