I am trying to link a MS SQL 2005 server with a Sybase SQL 5.0 database file. Has anyone ever had any luck doing this? What I want to do is connect the SQL box to our Fixed Asset Software (FAS) from Best (SAGE) software company.
I have read several articles and they keep referring to Sybase Anywhere 10.0 drivers for Windows. I have downloaded and installed Sybase 10.1 drivers and it failes to connect. I then tried installing FAS to my machine and creating a User DSN. FAS opens with no issues, but when I try to use a 3rd party tool to connect the 2 servers, I can authenticate to MS SQL but can never connect to the FAS DB.