I have an app running with sql2005 on wce5 and terminals symbol MC9090.Company changed the terminals by new one symbol MC9200. So I converted the app from VS2005 to VS2008, database from SQL2005 to SQL2008.I tested using the emulator on VS2008 and worked well.
I got the sql.wce5.armv4.cab and installed into the terminal. I got a message that it is not compatible, and it allow me to install it.When I execute the app, I am getting an error:
File or assembly name 'System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3', or one of its dependencies, was not found.
I guest that I need a new cab for wce7, something like this: sql.wce7.armv4.cab
After contacting Microsoft for support on this; they said me that In Windows Embedded Compact 7, SQL CE is distributed with the OS. Is this correct ?.... If so, how can we check in my device if it installed?
If I do cool boot, SQLCE is keeped or removed?
Do you have support for SQLCE on MC9200 device?
Thanks,
Irma
Windows embedded 7.// Expert user has replied. |
3 Replies
You need SQL CE 3.5.8080 (which is called SP2) or higher. It looks like you are running something older, because I think SP2 will show as 3.5.1, not 3.5.0. Check the version of the system.data.sqlserverce.dll that you are referencing. You might need to actually go to the file in the path where it's being referenced from to get the detailed version number. VS seems to only say 3.5.1 or 3.5.0.
I think this is the link to the 8080 version.
Download Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Mobile from Official Microsoft Download Center
The device comes with 3.5.8154 preloaded. There have been some instances where that has caused a conflict, but sometimes the 8080 version will work fine. If you are running 8080 or higher and are still having issues, you can try using a .reg file to remove references to 8154 and allow you to run whatever version you are building with. See this related post.
Another option is to install WEC7 platform builder on your PC and extract the 3.5.8154 dll from there. You could build your project using the 8154 version that comes on the device. Unfortunately that is a huge download, but that's the only way I am aware of to get that DLL.
Dan,
Really thanks for your quick response.
I installed the SQLCE SP2 8080 version. The problem was that yesterday I could not test it on the device because the WMDC sttoped to connect and even I could not connect as mass storage.
It is a good idea to install WCE7 on my laptop to complete testing and be sure to build the app with the right version as it is on device.
I checked WCE7 download, it is requesting 100GB free on the HD.
Maybe that could not be my option.
I will try with 8080 version, if not works well; then I will try with reg file.
Thanks,
Check the OS/BSP level of the MC9290. Some of the older ones did not have that SQL built in. Try some of the new ones.