How to connect to Sybase db using MS SQL Server 05?

[elmoxy]

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!

 

[MikeRose]

I am not sure if this helps, but for my MSSQL server to connect to Sybasa ASA 9.0 I needed to run the install which loaded the ODBC drivers ( correct DLL's) on my server. We use SSIS to connect to ASA9.0

 

[farhy]

The main question is how often do you need the data from Sybase, if you need it just once, use the import / export wizzard of SQL Server (in Management Studio: on Servername -> right mouse click-> import / export.

If you need it regulary, you can use the mentioned SSIS method, or maybe even easier for you, use a linked Server.
With a linked Server you can connect to a remote DB.