Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SaveDataSet via Custom Acess Classes
Message
From
29/10/2007 09:59:56
Ian Hammond
Greenfield Software Ltd
St. Neots, United Kingdom
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Using SaveDataSet via Custom Acess Classes
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01264721
Message ID:
01264721
Views:
54
I am trying to save my data via the MM SaveDataSet method to a backend FoxPro database. I have created my own custom data access classes as per the instructions in the MM.NET Deveopers Guide. When I execute the SaveDataSet method I get the following error:

...SoapException:Server was unable to process request.--> System.InvalidOperationException:OleDbCommand. Prepare method requires all parameters to have an explicitly set type followed by the stack trace.

When I created my custom server via the Data Adapter Configuration Wizard, the wizard only created code for the Select command and the Insert command. Do you need the code for Delete and Update? It so happens that my application only needs to insert the data into the database but the stack trace contains messages thus:

"......
at System.Data.OldDb.OleDbCommandBuilder.GetUpdateCommand()
at Oakleaf.MM.Main.Data.mmDataAccessOleDb.CreateUpdateCommand()
at Oakleaf.MM.Main.Data.mmDataAccessOleDb.SaveDataSet(etc....)
"

Could anyone throw any light on this and point me in the right direction,

Many thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform