locked
Connection Failure to Sybase RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    My case is:
    SO:   Windows 2008 Server R2.
    SSIS:  Visual Studio 2008.
    Driver Name:    Sybase ASE OLEDB Provider
    Driver Version: 15.0.0.325

    TITLE: Microsoft Visual Studio
    ------------------------------
    Error at Package1 [Connection manager "Server1"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E19.
    An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80040E19  Description: "[IM002]
    [Native Code: 30136]
    [ASEOLEDB]Data source not found and no default driver specified".

    Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Server1" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    When Test Connection is OK, but to excute the package get error message. Please help me?

     

     

    • Split by Todd McDermid Wednesday, June 30, 2010 1:07 AM New question
    Tuesday, June 29, 2010 11:04 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Are you developing on a 64 bit server? This may be a conflict between development running as 32 bit and execution running as 64 bit. As far as I know there is no 64 bit driver for Sybase.

    To work around, execute the packages as 32 bit through SQL Agent, or set the project property to Execute as 32 bit instead of 64 bit.

    James Beresford @ http://www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia ##### BI Monkey SSIS ETL Framework @ http://ssisetlframework.codeplex.com/
    Wednesday, June 30, 2010 1:22 AM