Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center > SQL Server Forums > SQL Server Integration Services > Connection Failure to Sybase

Answered Connection Failure to Sybase

    •  
      Tuesday, June 29, 2010 11:04 PM
       
       
      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?

       

       

       

    Answers

    • Wednesday, June 30, 2010 1:22 AM
       
       Answered
      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/