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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-28 : 13:32:25
|
| Abhijit writes "Hi,Following is my requirement.My Client has his database in Sybase 11.9.2 and I am developing a new application with database as SQL Server 2000 on NT 4.0/Win2K with latest service packs In my application I need to access few of the Sybase tables.My client has multiple copies of his Sybase databases all of which are in sync at any given moment. One of the requirement of my application is using some configuration parameters, my application should be able to connect to any of the Sybase databases.I have given a try to create a Linked Server for Sybase. If I have to access any table from Linked Server, I need to follow a specific syntax "LinkServerName.RemoteDatabaseName.OwnerName.TableName"Since Sybase has multiple copies of databases, LinkServerName and RemoteDatabasename are variable.If my SP is just returning a resultset out, there is no problem. But if the SP requires to create a Cursor for one of Sybase tables, I can't have the "select" query passed to Create Cursor as a variable name.How do I achieve this ? passing a variable to create Cursor ?This is my first question.My second question is can we link individual tables from a remote databaseinside one of the SQL Server databases without creating a Linked Server?This kind of functionality is available in MS AccessI would highly appreciate your answer. I would be obliged if you can mark a copy of your answer to my e-mail.Thanking YouRegards,Abhijit." |
|
|
|
|
|
Sybase Link Tables in SQL Server