I currently have 5 remote sites running Sybase and I need to extract
data from it at the end of every day into a Microsoft SQL Server database. I
am using ODBC to connect to the Sybase. The problem is that the DSN could
not connect to the remote database although it sits on the same LAN and
domain. I have no problems extracting data if the database sits on the local
machine where SQL Server is installed.