InvalidProgramException

rodmcleay · March 15th, 2006, 05:19 AM

Hi All,
I am getting an error on my Pocket PC device that throws an InvalidProgramException.
I am using VS.NET 2003 and developing for the PocketOC 2003 .NET Compact Framework 2003.
The error occurs in the Dataset Designer code for my JobGroupDataSet

Code:

 public virtual JobGroupDataSet.JobGroupDataTable GetData() {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            JobGroupDataSet.JobGroupDataTable dataTable = new JobGroupDataSet.JobGroupDataTable();
            this.Adapter.Fill(dataTable);//<<<ERROR ON THIS LINE
            return dataTable;

Any Help would be much appreciated.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

rodmcleay · March 16th, 2006, 10:07 PM

Problem found.
This error was caused by having SQLCE 3.0 installed on the device.
This stopped SQLCE 2.0 functioning and all my data access failed.
I ended up recreating the database in SQLCE 3.0 and all is working well now.
Is there a management utility for SQLCE?
I was not able to script or transfer my data directly with VS.NET?

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================