2603485 - Session failing to retrieve results using SSIS - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • 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

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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