Preserving, Protecting, and Enhancing the Environment
 



Home

Calendar

News

Discussion


Software Tools


Hardware

FAQ

References

Downloads



Login
Register

This content of this website is provided by LearningCE.com and the supporters of the Windows Embedded Student ChallengE. No endorsement by Microsoft is implied.


Home > Discussion > Software Tools

ChallengE Software Development Tools

Author Thread:
Can't find PInvoke DLL 'sqlceme30.dll'
CrystalP
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Sunday, June 04, 2006 7:00 PM (PST)

I was writing an application in C# to connect to sql server ce.

When i deployed the project into the eBoxII, the error happens at the statement where i create a SqlCeEngine object. the error info is  'can't find PInvoke DLL 'sqlceme30.dll' '. i definately installed the sql server ce mobile edtion SDK. And installed the .cab file in 'c:\program files\microsoft sql server mobile edition\device\mobile\v3.0\wce500\x86' to my device eBoxII. I can find the sqlceme30.dll in the device's \windows folder. So I wonder what the problem is?

Thank you for your help

 


Comments:

Author Thread:
jywilson
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Sunday, June 04, 2006 9:44 PM (PST)

I spend most of my time writing CE drivers and other system level software so I am a bit out of my element here.  But here's what I have turned up so far:

There is an interesting discussion regarding difficulties someone was having that produced the same error message you are receiving.  It is located here.

A few things I can add to that discussion which specifically apply to the eBox is this:

Unless you are including the options in your OS Design for a persistent registry, and the ROM-only file system, after you ran your installation of the CAB file on eBoxII, all of your settings and installed files would be lost on the next reboot.

What is really needed is a CE 5.0 Platform Builder component to allow SQL Mobile to be included in your OS design at build time.  Apparently this is in progress at Microsoft.  See the blog entry for more information.

Jim

CrystalP
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Monday, June 05, 2006 5:36 PM (PST)

Thank you for your answer.

I have reviewed the dicussion you provided to me. But i think it doesn't work to me. Indeed we met with the same problem. But the suggestion provided by Laxmi doesn't work as well. So could you please give me further suggestion? 

If not,  i just wonder whether the sql server 2005 mobile edtion could be used in the Windows CE-based device, like eBoxII. And whether the sql ce 2.0 could be used in a project developed in VS2005? Thank you!

jywilson
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Tuesday, June 06, 2006 6:18 AM (PST)

SQL CE 2.0 is supported in VS2005 and Platform Builder through the .NET CF 1.1 Framework, but not .NET CF 2.0, from what I can tell.  You should verify the latter assertion, however. I am not an expert on this topic, so I can't tell you anything about the differences between SQL CE 2.0 and SQL CE 3.0. 

There will soon be a Platform Builder component for SQL CE 3.0 on Windows CE 5.0 (next month from what I have read), so perhaps you can start your development in .NET CF 1.1 (SQL CE 2.0) and move over to .NET CF 2.0 (SQL CE 3.0) when the time comes.

Jim

coder_at_heart
Extremely Urgent
Posted: Wednesday, June 14, 2006 8:54 AM (PST)
Hello, We developed a simple Windows CE application in .NET CF that simply created a blank SQL Server Mobile database on the device [ebox]. The application builds and gets deployed successfully. But when it runs, it complains that sqlceme30.dll is missing and P\Invoke is not possible. Even though, the VS2005 transfers the cab files while deploying. We tried all sorts of solutions suggested by Laxmi and others, like- 1. Including all the 7 dlls in the project. 2. Pasting all the 7 dlls to the windows dir. 3. Transfering the cab files manually to the ebox and then installing them to create the dlls in the windows directory ...and more. Nothing has worked... We then tried to deploy it on a PocketPC emulator to find out that it runs successfully with no such exceptions. What could be the possible reason? How can we solve this problem? Top Urgent. Thanks Coder

coder_at_heart
Extremely Urgent
Posted: Wednesday, June 14, 2006 8:58 AM (PST)
Somewhr we read that VS only transfrers the cab files and does not install them [using wceload] Also, when we added all the 7 dlls to the project should we set its property to register them. Would this help? [ill try this tomorrow...]

jywilson
Extremely Urgent
Posted: Wednesday, June 14, 2006 10:44 AM (PST)

Is there anyway that you can use SQL CE 2.0, instead of 3.0?  As mentioned before, this is an alternative with a Platform Builder component, and should be easier to get installed.

Jim

coder_at_heart
TOP URGENT!!!
Posted: Thursday, June 15, 2006 12:07 PM (PST)
System.TypeLoadException was unhandled Message="File or assembly name 'System.Data.SqlServerCe, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=969DB8053D3322AC', or one of its dependencies, was not found." StackTrace: at System.Windows.Forms.Control.OnClick() at System.Windows.Forms.Button.OnClick() at System.Windows.Forms.ButtonBase.WnProc() at System.Windows.Forms.Control._InternalWnProc() at Microsoft.AGL.Forms.EVL.EnterMainLoop() at System.Windows.Forms.Application.Run() at DBTest1.Program.Main() We tried using Sql server ce instead of sql server mobile only to find more different problems. Pasted above is the statement of the exception. [We downloaded sql server ce, installed its development tools, included it in the winCe img and sysgen-ed it.] On encountering this error, we also tried including the dlls in the project. But it did not work. Kindly help as soon as possible

coder_at_heart
TOP URGENT!!!
Posted: Thursday, June 15, 2006 12:14 PM (PST)
We observe that a 'TypeLoadException' is thrown. So it seems, the code in SqlServerCe.dll is refering to some type which is present in a dll that is not a part of the project or the OS. So can you let us know what are the dependencies of this SqlServerCe.dll. And how we can include them to remove this error...

selmaguzel
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Sunday, November 02, 2008 11:44 PM (PST)

Hi, I get the same error above.

When I add SQL Mobile and/or SQL Mobile .Net 2.0 Data Provider in the OS Design, I get error and can not build the Platform Builder project.

Only I am allowed to add SQL Server Ce 2.0 and SQL Server .Net 2.0 Data Provider to the project.But at this time, I get 'Can't find PInvoke DLL 'sqlceme30.dll'  error when I run the VS2005 C# application, despite of adding dlls to the application project folder.

 

What must I do?

 

Thanks in advance.

selmaguzel
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Sunday, November 02, 2008 11:50 PM (PST)

Hi,

I get the same error.

I can't add Sql Mobile and SQL Mobile .Net 2.0 Data Provider to my Platform Builder project.Namely if i add i can not build.Only I can build without errors if I add SQl Server Ce 2.0 and SQL Server :net 2.0 provider.

But at that time, i get the error Can't find PInvoke DLL 'sqlceme30.dll'  despite of adding dlls to the application folder.

Have you solved your problem?What must I do?

 

 

selmaguzel
Can't find PInvoke DLL 'sqlceme30.dll'
Posted: Sunday, November 02, 2008 11:50 PM (PST)

Hi,

I get the same error.

I can't add Sql Mobile and SQL Mobile .Net 2.0 Data Provider to my Platform Builder project.Namely if i add i can not build.Only I can build without errors if I add SQl Server Ce 2.0 and SQL Server :net 2.0 provider.

But at that time, i get the error Can't find PInvoke DLL 'sqlceme30.dll'  despite of adding dlls to the application folder.

Have you solved your problem?What must I do?

 

selmaguzel
TOP URGENT!!!
Posted: Sunday, November 02, 2008 11:51 PM (PST)

Hi,

I get the same error.

I can't add Sql Mobile and SQL Mobile .Net 2.0 Data Provider to my Platform Builder project.Namely if i add i can not build.Only I can build without errors if I add SQl Server Ce 2.0 and SQL Server :net 2.0 provider.

But at that time, i get the error Can't find PInvoke DLL 'sqlceme30.dll'  despite of adding dlls to the application folder.

Have you solved your problem?What must I do?

 

samp
TOP URGENT!!!
Posted: Monday, November 03, 2008 9:43 AM (PST)

Are you using CoreCon to establish a connection to the eBox and deploy your application to eBox?

When you deploy the application to the eBox using CoreCon, a folder is created for your application in the “\Program Files” directory.  I believe the squlceme30.dll binary is copied to this application folder.

Which version of Windows CE are you using 5.0 or 6.0?

If you are using 6.0, download and use the “ICOP_Vortex86_60CS_BSP.msi” from the following URL.

http://www.embeddedpc.net/Download/WindowsEmbeddedCE60Download/tabid/113/Default.aspx

When you create the OS design using the “ICOP_Vortex86_60CS” BSP, in addition the component needed for your project, include the following component to the OS design:

  -  CAB File Installer/Uninstaller

  -  RAM and ROM File System

  -  Hive-based registry

Set the following environment variables:

  -  PRJ_ENABLE_FSREGHIVE = 1

  -  PRJ_ENABLE_FSMOUNTASROOT = 1

  -  PRJ_BOOTDEVICE_ATAPI = 1

-----------------------------------------------------------------

Using the OS image built with the above configuration, you can deploy your VS2005 application to eBox using CoreCon.  When you download the application from the VS2005 development workstation to the eBox, it create an application folder under the \PROGRAM FILES directory and copy the application binary and needed files to this folder.

Since we set the OS design to build an image with “RAM & ROM file system” and mount the file system at the storage device's root (PRJ_ENABLE_FSMOUNTASROOT), a copy of this folder including its contents (your application and support files) are copied to the eBox's internal IDE flash storage. 

Note:  You need to manually copy the NK.BIN image file to the eBox's root.

With the above, you should be able to launch your application.

Hope this help resolve your problem.

Samuel Phung [eMVP]

 
Hosted By: LearningCE.com

New Posts

  • LogoScreen Windows CE 5.0
    Posted by PaleX on Friday, August 21, 2009 (PST)

  • Device Management Server
    Posted by BigDoc on Wednesday, October 31, 2007 (PST)

  • Launching Application in CE
    Posted by user404 on Thursday, October 18, 2007 (PST)

  •  

    New Downloads

  • Transcript of 4/11 WESC Chat for Teams in N and S America/Europe
    Transcript of the 4/11/06 technical chat held for teams in N and S America and Europe.

  • Transcript of 4/13 WESC Chat for Teams in Asia/Australia
    Transcript of the 4/13/06 technical chat held for teams in Asia and Australia.

  • Transcript of 3/30 WESC Chat for Teams in Asia/Australia
    Transcript of the 3/30/06 technical chat held for teams in Asia and Australia.

  •  

    New Events

  • ChallengE Finals
    The finals will be held in Redmond, Washington on June 23-24, 2006

  • Finalists Announced
    The finalists for the ChallengE will be announced on this date.

  • Judging of Final Reports Ends
    Judging Ends...



  • Last Refreshed 2/5/2012 9:00:54 AM
    Home   |  Calendar   |  News   |  Discussion   |  FAQ   |  References   |  Downloads