Karl,

Did you figure this out yet?

If not, I noticed, looking back through this error call stack, that mmDataAccessVistaDB.SaveDataSet() calls mmDataAccessSql.CreateInsertCommand()? I haven't updated to the latest MM.NET version yet, but is that correct? You may want to step through it to be sure you didn't jump data access tracks in the middle of your update.

Hope that helps,
---J

>I get a commandbuilder error when trying to save a dataset works with sql server
>
>specifically is asking for select insert commands??
>
>perplexed
>
>error message follows
>
>
>at System.Data.Common.CommandBuilder.BuildCache(Boolean closeConnection)
> at System.Data.SqlClient.SqlCommandBuilder.GetInsertCommand()
> at OakLeaf.MM.Main.Data.mmDataAccessSql.CreateInsertCommand()
> at OakLeaf.MM.Main.Data.mmDataAccessVistaDB.SaveDataSet(DataSet ds, String tableName, String primaryKeyName, Boolean retrieveAutoIncrementPK, IDbDataAdapter dbAdapter)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName)
> at ProjectPublisherBasicInterface.frmProjectSetup.btnOK_Click(Object sender, EventArgs e) in c:\my projects\projectpublisherbasic\ppbasicinterface\projectsetupform.cs:line 461
> at System.Windows.Forms.Control.OnClick(EventArgs e)
> at System.Windows.Forms.Button.OnClick(EventArgs e)
> at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
> at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at System.Windows.Forms.ButtonBase.WndProc(Message& m)
> at System.Windows.Forms.Button.WndProc(Message& m)
> at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
> at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
> at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
> at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
> at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
> at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
> at System.Windows.Forms.Application.RunDialog(Form form)
> at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
> at System.Windows.Forms.Form.ShowDialog()
> at OakLeaf.MM.Main.Windows.Forms.mmFormManager.ShowDialog(Form form)
> at ProjectPublisherBasicInterface.Main.Windows.Forms.MainForm.FileNewProjectBar_Click(Object sender, EventArgs e) in C:\My Projects\ProjectPublisherBasic\PPBasicInterface\MainForm.cs:line 325
> at System.Windows.Forms.MenuItem.OnClick(EventArgs e)
> at System.Windows.Forms.MenuItemData.Execute()
> at System.Windows.Forms.Command.Invoke()
> at System.Windows.Forms.Control.WmCommand(Message& m)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
> at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
> at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
> at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
> at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
> at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
> at System.Windows.Forms.Application.Run(Form mainForm)
> at ProjectPublisherBasicInterface.Main.AppMainEntry.Main() in C:\My Projects\ProjectPublisherBasic\PPBasicInterface\Main.cs:line 45