Question

  Asked: May 5 2008   9:06 PM GMT
  Asked by: Bhassel


Connect to Sybase ASE 15 via MS SQL 2005


Sybase, Sybase ASE 15, SQL Server 2005

I'm in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Install the Sybase drivers on the SQL Server, and configure them as needed.

You can then create a linked server from the SQL Server to the Sybase server and access the objects using the four part object name.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement, Linux and SQL Server.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   May 14 2008  8:47AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.