June 11, 2004 at 6:16 am
I need to pull a copy of tables for a Adaptive Server Anywhere 8 database. I would like to setup as a DTS package because it's going to be a reocurring job. Is there a connection object for Adaptive Server Anywhere 8? Or how would go about pulling these tables?
Arthur Lorenzini
June 11, 2004 at 7:39 am
Usually the connection object drivers are provided by the vendor. For the most part on the machine they are installed on they will be viisble for use in DTS (make sure they are on the server where the DTS package will run as well as where you develope). However if they are not you can always use a System ODBC connection to access the drivers as well. But you will need the client drivers from Adaptive Server.
June 11, 2004 at 8:11 am
I have used DTS jobs to connect to sysbase 11.5 and 12.5. In both cases I installed the adaptive server PC client software on the sql server, then setup an odbc data source.
Steven
June 11, 2004 at 8:31 am
I just got done installing the Sybase client software and setting up a DTS package and it seems to be working. Thanks everybody for the heads up.
Arthur Lorenzini
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply