1864287 - ADO.Net: CommandTimeout, Exception thrown: UnhandledException: System.NullReferenceException: Object reference not set to an instance of an object - SDK for SAP ASE

• CommandTimeout causing Exceptions using ASE ADO.NET Data Provider
• Exception: System.InvalidOperationException: Cannot execute a command without opening the Connection
• Unhandled Exception: System.NullReferenceException: Object reference not set to an instance of an object
• In some cases an active transaction exists on the ASE database which can lock the resource, such as a table. This will occur when CommandTimeout occurs (Error" "The command has timed out"). The application Connection status is marked Open but the connection is disconnected form the ASE
• In all cases, as mentioned, ADO.NET Connection status is marked as Open but the physical connection to SAP Sybase ASE is disconnected

• SAP Sybase Software Developer Kit (SDK) 15.7
• Adaptive Server Enterprise ADO.NET Data Provider
  • 2.0 Provider ( Sybase.AdoNet2.AseClient.dll )
  • 3.5 Provider ( Sybase.AdoNet35.AseClient.dll )
  • 4.0 Provider ( Sybase.AdoNet4.AseClient.dll )
• SAP Sybase ASE 15.7
• Visual Studio 2008/2010
• Microsoft .NET Framework 2.0 to 4.0
• Developed in C#, VB.NET
• Windows 7, 2008, 2008 R2 x64 (can also happen with Windows XP x86/x64)

CR#722918, CR722918 , KBA , BC-SYB-SDK , SDK , Bug Filed