Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
 Posted - 2002-08-11 : 15:20:51
|
| Hi, fellows!!Anyone has any experience on setting up a Linked Server to a Informix Server, and execute SP on it? I can succesfully set the Linked Server and executing some queries, but cannot exec SPs.Any Idea?Best Regards, |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-08-11 : 20:11:29
|
| Hi, Never Mind. I found a workaround:Hi, There is a WorkAround to exec SP on Heterogeneous DataSource: 1) I use it against a Informix Server; 2) I Use OleDB provider for ODBC Database; 3) The proc MUST return a Result Set; Well, the trick is to use the OpenQuery Function: select * from openquery(linked_server, "Execute procedure using remote syntax") It works because the openquery functio don't parse the SQL Command, and since the proc returns a result set tha can be fetched, described using native SQLODBC Calls, the results are showed. The only issue is that for Informix (I don't tested against a Sybase), it will not return column names.. Best regards, Sérgio |
 |
|
|
|
|
|
Linked Server