Version 5 - Integration to SQL 2000

[rongroening]

Hi everyone,

I am hoping someone here will be able to point me in the
correct direction on this. I have a customer which is using
a Sybase SQL Anywhere 5.0 database as a POS frontend system.
This database holds all transactional information, and I
need to integrate summary information into a SQL 2000
Standard database, running on Windows 2003 Server, with the
final destination being a Microsoft Dynamics GP system.

The Sybase system will be running in various seperate sites,
and VPN connections will be available to connect to these
locations and pull data. My problem is I am unaware how to
setup the ODBC connection on the server machine in order to
connect to the Sybase database. Any assistance would be
greatly appreciated.