Can MS SQL Server 2005 be set up to connect to Sybase ASE 12.5 DB?

[elmoxy]

Programmers Area - Sybase: Adaptive (SQL) Server Forum
elmoxy (TechnicalUser)1 replies20 Jul 10 (12 Jul 10)
How to connect to Sybase db using MS SQL Server 05?
I'm wondering if it's possible to use MS SQL Server 2005 to connect to a Sybase ASE 12.5 database. The Sybase db is located in a remote location as it is owned by another company; however, they gave us the IP address and port number as well as a username/password for the reporting database. Also, they gave us these instructions on how to set up an ODBC connection.
1. Double click on Data Source (ODBC)
2. Select the System DSN tab - Double click on the Sybase ASE ODBC driver
3. Select the General tab
4. Key in Source Name provided within the Data Source Name
5. Within the Network Library Name field key in Winsock
6. Within the Network Address field key in the Report Database IP Address and port (put in a comma between the IP & port #)
7. Within the Database Name key in the report database name that you will be accessing.
8. Press Apply
9. Connection established message should appear
The ODBC connection works with Crystal XI developer edition, but I'm wondering if I can use MS SQL Server 2005 to see all the tables/views on the Sybase reports database. Unfortunately, I don't have admin rights on my machine but my IT dept installed the SQL Server software for me. I then go to MS SQL Server 2005 -> SQL Server Management Studio. This is where I get lost, I don't know if I need to define some additional settings here that will allow my ODBC connection to work. Can anyone provide some insight into this? It would be really appreciated. Thanks!

 

[gmmastros]

I've never done it, but I would suggest you start here:

How to set up a linked server to a Sybase database server and troubleshoot problems that may occur

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

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[elmoxy]

gmmastros,

Thanks for the reply. I'll start there and see how it goes.

 

[TheBugSlayer]

The only way is to set it up as a linked server. Expand the Server Objects node then Linked Server. You have all the necessary information and should be good to go if the necessay Provider is installed. I know Microsoft SQL Server .NET Data Provider works with Sybase. Good luck.

MCITP SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)