Home > IT Answers > DataManagement > Connect to Sybase ASE 15 via MS SQL 2005
Help

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
Help

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

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: May 14 2008  8:47 AM GMT  by Mrdenny




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.


RSS - Discussions Help

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.