SAP Knowledge Base Article - Preview

2161362 - ADO.NET provider fails due to message and disconnects, unable to continue with session - SAP SDK

Symptom

  • On a login that requires to set role with password, during login, ADO.NET provider fails due to message and disconnects, unable to continue with session
  • ASE ADO.NET provider (and ASE ODBC) will disconnect on the message when Exception is thrown:
     
    • TestLogin
      Hello from TestLogin, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
      Conn string: Data Source=asehost:10051;user id=xxxxx;password=xxxxxx;sqlinitstring=set role TESTADO with passwd 'password' on
      Provider version: 16.0.0.5
      AseException: Sybase.Data.AseClient.AseException: Password required to set role 'TESTADO' on. <---- MESSAGE (NON FATAL)
    • at Sybase.Data.AseClient1.AseConnection.Open()
      at Sybase.Data.AseClient.AseConnection.Open()
      at TestRole.Program.Main(String[] args) in c:\...\TestLogin\Program.cs:line 31
    • The Connection state is:
    • ClosedException2: System.InvalidOperationException: Cannot execute a command without opening the Connection
      at Sybase.Data.AseClient1.AseCommand.Execute(CommandBehavior commandBehavior)
      at Sybase.Data.AseClient1.AseCommand._ExecuteReader(CommandBehavior commandBehavior)
      at Sybase.Data.AseClient1.AseCommand.ExecuteReader()
      at Sybase.Data.AseClient.AseCommand.ExecuteReader()
      at TestRole.Program.Main(String[] args) in c:\...\TestLogin\Program.cs:line 57


Read more...

Environment

  • SAP Sybase Software Developers Kit (SDK) 15.7
  • SAP Software Developers Kit (SDK) for Adaptive Server Enterprise (ASE) 16.0
  • Microsoft Visual Studio 2010 / 2012 / 2013 / 2015
  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
  • Adaptive Server Enterprise ADO.NET Data Provider

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

Keywords

adonet, .net, Sybase.Data.AseClient, Sybase.AdoNet2.AseClient.dll, Sybase.AdoNet35.AseClient.dll,Sybase.AdoNet4.AseClient.dll, Sybase.AdoNet45.AseClient.dll, SDK for SAP ASE, CR#783187, CR783187, 783187 , KBA , BC-SYB-SDK , SDK , 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.