Execute sybase stored procedure as linked server procedure sql server 2008

sql sql-server tsql linked-server sybase-asa
Mauro picture Mauro · Feb 22, 2011 · Viewed 8k times · Source

EDIT

The final goal is to call a stored procedure hosted in sybase with input and output parameters from SQL Server 2008 via Linked Server

I think title is pretty clear.

My goal is to execute a stored procedure hosted in Sybase SQL Anywhere 8 in SQL Server 2008 through the linked server I already created.

Any SQL query made through the linked server is working. In addition I was able to execute a function but I don't now how to get the return value like that

EXEC ('CALL "dbname"."procedurename"(''param1'', ''param2'', ''param3'')') AT LinkedServerAlias;

Thanks 4 all your help!

Mauro

Answer

Piotr Rodak picture Piotr Rodak · Feb 22, 2011

can you use four part naming convention?

like

exec LinkedServerName.dbname.dbo.procedurename @param1, @param2, @param3

Related questions

Cross-server SQL

I want to port data from one server's database to another server's database. The databases are both on a different mssql 2005 server. Replication is probably not an option since the destination database is generated from scratch on a [time interval] …

Read More
How can I connect to an external database from a sql statement or a stored procedure?

When running a SQL statement or a stored procedure on a database, can you connect to an external database and pull data from there? something like: SELECT a.UserID, b.DataIWantToGet FROM mydb.Users as a, externaldb.Data as b

Read More
catastrophic failure trying to select from linked server

I have created a linked oledb/odbc connection to Pervasive SQL from SQL SERVER 2012: USE [master] GO /****** Object: LinkedServer [KSLAP208] Script Date: 2/8/2013 10:38:55 AM ******/ EXEC master.dbo.sp_addlinkedserver @server = N'KSLAP208', @srvproduct=N'Pervasive ODBC Interface', @provider=N'MSDASQL', @datasrc=N'C003', @…

Read More