SAP Knowledge Base Article - Preview

2603485 - Session failing to retrieve results using SSIS - SAP ASE


  • Using Microsoft SQL Server Integration Services (SSIS) to connect to ASE to run a query
  • The query returns no results
  • sp_who show the connection in a "waiting" status
  • The same SSIS connection to another ASE server returns the correct result
  • Running the query using isql returns the correct result



SAP Adaptive Server Enterprise (ASE) 15.7


SAP Adaptive Server Enterprise 15.7


change driver, sql, result, connection issue, fails to connect, result set , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.