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
No comments:
Post a Comment