Tuesday, February 14, 2012

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

No comments:

Post a Comment