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
- 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) , Known Error
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.