Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SaveDataSet via Custom Acess Classes
Message
From
31/10/2007 04:55:39
Ian Hammond
Greenfield Software Ltd
St. Neots, United Kingdom
 
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01264721
Message ID:
01265288
Views:
6
Hi Kevin,

As requested, please find the complete stack trace as follows:

System.Web.Services.Protocols.SoapException was unhandled
Message="System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: OleDbCommand.Prepare method requires all parameters to have an explicitly set type.\r\n
at System.Data.OleDb.OleDbParameter.Prepare(OleDbCommand cmd)\r\n
at System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount)\r\n
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)\r\n
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)\r\n
at System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)\r\n
at System.Data.Common.DbCommandBuilder.GetSchemaTable(DbCommand sourceCommand)\r\n
at System.Data.Common.DbCommandBuilder.BuildCache(Boolean closeConnection, DataRow dataRow, Boolean useColumnsForParameterNames)\r\n
at System.Data.OleDb.OleDbCommandBuilder.GetUpdateCommand()\r\n
at OakLeaf.MM.Main.Data.mmDataAccessOleDb.CreateUpdateCommand()\r\n
at OakLeaf.MM.Main.Data.mmDataAccessOleDb.SaveDataSet(DataSet ds, String tableName, String primaryKeyName, Boolean retrieveAutoIncrementPK, IDbDataAdapter dbAdapter)\r\n
at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter)\r\n
at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey)\r\n
at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName)\r\n
at Greenfield.PocketGrowmaster.Business.Invoices.UpdateDataBase() in F:\\DevPsiPro\\NewPsion\\Sales System Business Objs\\Invoices.cs:line 536\r\n
at PocketGrowmasterWS.SaveAdviceNotes(String ticket, DataSet dsHeader, DataSet dsDetails) in f:\\DevPsiPro\\NewPsion\\PocketGrowmaster Web Service\\App_Code\\PocketGrowmasterWS.cs:line 449\r\n
--- End of inner exception stack trace ---"
Actor=""
Lang=""
Node=""
Role=""
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.doInvoke()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke()
at DeviceApplication1.PocketGM.PocketGrowmasterWS.SaveAdviceNotes()
at Greenfield.PocketGrowmaster.Connect.Service.SaveAdviceNotes()
at Greenfield.PocketGrowmaster.MainForm.buttonSend_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at Greenfield.PocketGrowmaster.Program.Main()


Regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform