Comments:

Flat Nested Threaded Embedded

Oldest First Newest First

Author	Thread:
coder_at_heart	Any mobile Windows compatible with SQL CE/ME Posted: Saturday, June 17, 2006 4:14 AM (PST) I am open to trying one more thing. Instead of a mobile version of windows, I choose to use ordinary windows, say 2000/ME/XP. And I would like to install a SQL Server CE/ME on it and run .NET CF applications. So the EBox is replaced by another full fledged PC with Windows XP. I connect to it to debug my applications. Till your june update comes. Atleast I can save on the time...I have already lost what, a week or so in the above problem.
jywilson	Any mobile Windows compatible with SQL CE/ME Posted: Saturday, June 17, 2006 5:19 AM (PST) Okay, I think I have an OS Design for eBoxII that will run SQL CE 2.0, .NET CF 2.0 code.  Go ahead and post a reply with some sample code that I can include in my build to verify that it is capable of running your app. If it works, I will tell you the steps I followed. Jim
jywilson	Any mobile Windows compatible with SQL CE/ME Posted: Saturday, June 17, 2006 8:37 AM (PST) Okay, I managed to get things working for SQLCE 3.0.  Here is what I did. I couldn't wait for your app, so I found one at this website.  It creates a basic database and displays a form to populate it with records.  Check it out to make sure it is representative of what you are doing in your app.  Even though it indicated that it was for SQLCE 2.0, it seemed to work just fine with SQLCE 3.0. Build an OS Design for the eBoxII and got it uploaded and running.  I recommend you include a component that provides some form of persistent registry capability so that you won't have to reinstall the CAB files used in the next few steps. Navigate to the .\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\x86 directory and install all three cab files to the eBoxII. You will need one additional file located in the $(WINCEROOT)\OTHERS\DOTNET\X86 directory, sscemw20.dll.  Copy this file so that it is located somewhere in the search path (ex: \Windows or your application directory). You may notice that when you build your app in VS2005 that the BIN directory contains a few other DLL's and XML files.  These files will need to be copied to your app directory on the eBox, in addition to the .EXE module. That should do it.  Again to make these changes persistent you will need to use one of the options which causes the registry to be saved in Flash.  There is a reference to the procedure for doing this located here. Please let us all know how things go. Onward!
coder_at_heart	Any mobile Windows compatible with SQL CE/ME Posted: Sunday, June 18, 2006 11:55 PM (PST) Hi JYW! Things just as grim as it were. No change, the same error. Let me give you complete details:   Error statement: "Can't Find PInvoke DLL 'sqlceme30.dll'. when we click the 'Create DB' button.   1. The application code: All we have is a simple WinCE 5.0 device application that has a form with only a button that reads 'Create DB' on it. The button click event is associated to this code. private void btnCreateDB_Click(object sender, EventArgs e) { SqlCeConnection sqlCeConnection = null; MessageBox.Show("Entering try block"); try { if (!File.Exists(@"\My Documents\Test.sdf")) { SqlCeEngine sqlCeEngine = new SqlCeEngine(@"Data Source = \My Documents\Test.sdf"); sqlCeEngine.CreateDatabase(); MessageBox.Show("Create successful"); } sqlCeConnection = new SqlCeConnection(@"Data Source = \My Documents\Test.sdf"); sqlCeConnection.Open(); MessageBox.Show("Open successful"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (sqlCeConnection != null) sqlCeConnection.Close(); } }   2. The project included among other references System.Data.SqlServerCe (Version 3.0.x). We also included the following files * sqlce30.dev.ENU.wce5.x86.CAB * sqlce30.repl.wce5.x86.CAB * sqlce30.wce5.x86.CAB * sscemw20.dll * System.Data.SqlServerCe.dll (Version 3.0.x) * System.Data.SqlServerCe.xml (The only xml file that was created in the bin after building the project) The 'Copy to Output directory' property was set to 'Copy Always' for each of the six items above.     3. On deployment, the application folder on the device contained following files: * The application exe (dbtest1.exe) * the 3 cab files above * sscemw20.dll * System.Data.SqlServerCe.dll (Version 3.0.x) * System.Data.SqlServerCe.xml * A file with name 514c36bf-c13e-4091-a3a7-1e566227b20d and no extension.   On executing the CAB files following files were created (we chose the Windows folder)- * isqlw30.exe * sqlceca30.dll * sqlcecompact30.dll * sqlceer30EN.dll * sqlceme30.dll * sqlceoledb30.dll * sqlceqp30.dll * sqlcese30.dll * GAC_System.Data.SqlServerCe_v3_0_3600_0_cneutral_1.dll * GAC_System.Data.SqlServerCe.resources_v3_0_3600_0_cen_1.dll   4. We used the Internet Appliance template for the WinCE image and included following components: * wceload * network utilities (ipconfig etc) * .net cf 2.0 We did not include the persistent registry components for the time being. In case it works, we'll do that as well. We also tried one more thing: We run the query analyzer (isqlw30.exe) to create a new database. The create database dialog reported the following error: 'Failed to initialize the provider. Please make sure that SQL Server Mobile Edition is properly installed.' Kindly help as soon as possible. Time is running out...   I think the last thing we can do is that you send your nk.bin and the project folder to us. Even if this does not work then your machine is magical! Bbye! Coder