Symptom
While creating EDM (Entity Data Model) project in Visual Studio (2010 in this case) to model and execute ASE (Adaptive Server Enterprise) stored procedures with output parameter as char/varchar, Exception is thrown:
Exception: System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Runtime.InteropServices.SEHException: External component has thrown an exception.
at Sybase.Data.AseClient.Unmanaged.BindParameter(IntPtr pCommandHandle, String paramName, AseDbType sqlType, Int32 precision, Int32 scale, String value, ParameterDirection direction, Int32 size, Int32 isNull)
at Sybase.Data.AseClient1.AseCommand.BindParameters()
at Sybase.Data.AseClient1.AseCommand.Execute(CommandBehavior commandBehavior)
at Sybase.Data.AseClient1.AseCommand._ExecuteReader(CommandBehavior commandBehavior)
at Sybase.Data.AseClient1.AseCommand.ExecuteReader(CommandBehavior commandBehavior)
at Sybase.Data.AseClient.AseCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyMetadataCollection`1 entitySets, EdmType[] edmTypes, MergeOption mergeOption)
at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters)
at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters)
at InOutTest.pubs3Entities.storeid_proc_out(String stor_id, ObjectParameter stor_name_out) in C:\...\Model1.Designer.cs:line 128
Read more...
Environment
- SAP ASE SDK 15.7 SP121, 4.0 ADO.NET Provider (4.157.1212.0)
- ASE 15.7
- msdev (Visual Studio) 2010 using EDM 4.0, EF (Entity Framework) 4.0
- Windows x86/x64, Win 7/2008R2
Product
Keywords
framework, edm, adodotnet, parms, "output parm", "output parms", param, params , KBA , BC-SYB-SDK , SDK , Bug Filed
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.