connect sql server to sybase 12 ????

[goland]

I have sever 2000 on a box (172.16.1.22)and I am trying to coonect to a sysbase 12 DB on a different server 172.16.1.3 to extract the data.
Does anyone have any input on a simple way to do this?
Thanks in advance.
Wyles

 

[msdhanjal]

They have this Link on Microsoft resource PAge, I think it Should Do the Trick.
We had Done similar Work With DB2 to Sql Server.

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0661.mspx

Maninder

 

[mrdenny]

Install the Sybase 12 drivers on the SQL Server, setup a linked server to the Sybase server and access the data you need accross the linked server. Check out linked servers in BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)