Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I add a Sybase ASA 9 provider to Microsoft SQL Server 2005

Posted on 2011-03-18
3
Medium Priority
?
461 Views
Last Modified: 2012-05-11
I'm trying to create a linked server in Microsoft SQL Server 2005 to a Sybase database. I would like to use the Sybase ASA as my provider for setting up the link but I'm not sure where to download and how to install in SQL.
0
Comment
Question by:dbfc
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35165951
You need Sybase client tools installed, follow this KB:

http://support.microsoft.com/kb/280102
0
 

Author Comment

by:dbfc
ID: 35166278
Thanks for the reply Daniel. I've actually seen this KB, I'm just having a hard time obtaining the client tools. Any idea where I can find these? I haven't had a lot of luck on the Sybase website.
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 2000 total points
ID: 35166471
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Loops Section Overview

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question