MissingMethodException w/ SqlConnection

[Guest]

Hey,
I'm getting a MissingMethodException when I call Open() on a SqlConnection -- but only on my WindowsCE device. The program runs fine in the pocketPC emulator and the same code also works fine on the PC.

So -- how do I ensure that the System.Data.SqlClient library is being copied on the device correctly? I set the reference to copy locally and I can see it there...

ideas?

- Zack

P.S. One thing worries me and is a half-related question:
I can only deploy my project to the Windows CE device if I tell VisualStudio to deploy to a PocketPC device. If I specify the WindowsCE device the deploy halts when trying to send the first file. Why does VS only want to deploy my program as a PPC? And why does the WindowsCE device accept the PPC version? thoughts?

 

[Peter Foot [MVP]]

Can you use the developer tools which ship with SqlCe to open the database
on the device and look at the tables etc. You should be able to find the cab
installers for SqlCe and the developer tools in the subfolder which matches
the cpu type on your device e.g.
C:\Program Files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows
CE\wce400\armv4\sql.wce4.armv4.cab

Peter