March 4, 2020 at 5:28 pm
I have linked server setup between sql server to sybase. I have a store procedure which works directly against sybase which is trying to insert values and the column name is declared wrong. However, it does not work using linked server from SQL Server. It is strange that why it worked in sybase any idea?
March 4, 2020 at 6:41 pm
Not enough information - and not real sure what problem you are encountering. Is there an error? How are you calling this stored procedure? Where does the stored procedure live?
If you are trying to move a stored procedure from Sybase to SQL Server...they are different platforms and have many differences that will not transfer across...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 4, 2020 at 6:49 pm
I am not trying to move the store proc from Sybase to sql server. I am trying to run the sybase store proc from SQL Server using linked server. So without linked server when i run it directly in sybase it works fine even though the column name is declared wrong in store proc. But when i run using from SQL Server using Linked server it throws the error which is valid. The error is misleading because it says it does not allow nulls, but the actual problem is the column name is declared wrong in the proc.
March 4, 2020 at 7:31 pm
Try using Openquery to execute the Sybase stored procedure. It may or may not work. You would want to post the exact error message and error number when you get something that doesn't work.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply