Connecting to Sybase

Hi,

I am assuming someone has had success connecting to Sybase from SSIS. I am having trouble. And I freely admit naivety when it comes to something like this. :-)

I installed dbConnector 6.01 which has a Sybase connector as a part of the package. I then tried to create a connection manager for Sybase using OleDb, but it was not an option in the list of OleDb connections. So, am I correct in assuming that I need to use ODBC? If so, is there an OleDb Sybase driver that can be used with SSIS?

Any help in using SSIS to connect to Sybase would be appreciated.

Thanks,

- Joel

Joel,
I've had success connecting to Sybase ASE 12.5.X using OLEDB. The question that needs to be answered, is what type/version of Sybase are you running. Is it Sybase Adaptive Server Anywhere, Sybase Adaptive Server Enterprise, or Sybase SQL Anywhere and what version is it? Depending on the product/version you may be able to get OLE DB drivers from Sybase itself.
I got the OLE DB drivers from the PC Client software that was included in my installation of ASE.
Larry Pope
|||Thank you Larry for your reply. The Sybase database that I want to connect to is version 11.5.1.2.|||Joel,
I've searched the Sybase site and they no longer have any downloads for your version of the software. That isn't really surprising since it is over 5 years old.
If I may ask what type of system is using it? Is it hosting some custom application or is it supporting some commercial application?
If it is supporting a commercial product you might want to ask the vendor to see about OLE DB providers. If it is a standalone install supporting a custom application then you may need to check the original software media for the PC Client tools. I know in my case they were included on the same CD as the server software.
Larry Pope

|||

Hi Larry,

Thanks again for th reply. I think we got it figured out. We installed a more recent driver (ASE) and was able to connect to Sybase through ODBC and OleDb.

- Joel

|||

So we are trying to do something similar. SYBASE ASE 12.5.3

We downloaded the 12.5.1 SDK and installed. Our choices via SSIS as far providers was the same.

We downloaded the 15.0 SDK and installed. Our choices via SSIS as far providers changed to include Sybase OLEDB Provider.

We are still not having any luck connecting., Any help would be appreciated.

TIA