I've already told you that simply adding some dll files to the Windows
folder DOESN'T MAKE IT WORK.
Paul T.
Post by jpkongAs I added system.data.sqlserverce.dll into the Windows folder of target,
I launched the web server.
When I try to see the web page working with DB,
tt made an following error with web server.
Web server is aborted without any message to web browser.
--------------------------------------------------------------------------
Data Abort: Thread=860e9000 Proc=8223b5e0 'ocfhttpd.exe'
AKY=00000401 PC=02244008(sqlceme35.dll+0x00004008)
RA=00630041(ocfhttpd.exe+0x00620041) BVA=16630065 FSR=00000003
ocfhttpd.exeErrorA native exception has occurred in ocfhttpd.exe.
Select Quit and then restart this program, or select Details for more
information.
ocfhttpd.exeErrorExceptionCode: 0x80000002
ExceptionAddress: 0x02244008
System.Net.Sockets.SocketException at 01/01/03 07:01:19
Runtime true terminating
Message: An error message cannot be displayed because an optional resource
assembly containing it cannot be found
Stack trace: at System.Net.Sockets.Socket.AcceptNoCheck()
at AcceptAsyncRequest.doRequest()
at AsyncRequest.handleRequest()
at WorkerThread.doWork()
at WorkerThread.doWorkI()
at WorkItem.doWork()
at System.Threading.Timer.ring()
Data Abort: Thread=860e9000 Proc=8223b5e0 'ocfhttpd.exe'
AKY=00000401 PC=02244008(sqlceme35.dll+0x00004008)
RA=00630041(ocfhttpd.exe+0x00620041) BVA=16630065 FSR=00000003
--------------------------------------------------------------------------
But, when the web server is running without system.data.sqlserverce.dll in
the target, it doesn't go down.
It just give the error message below to the web browser.
Server Error in '/Cardholder.aspx' Application.
--------------------------------------------------------------------------------
Description: File or assembly name 'System.Data.SqlServerCe,
Version=3.5.0.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3', or one of
its dependencies, was not found.
Error Message: System.TypeLoadException: File or assembly name
'System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral,
PublicKeyToken=3BE235DF1C8D2AD3', or one of its dependencies, was not found.
at BLL.Common.GetTableCount() at
SicunetWeb.Common.Utility.GetTableCount1()
at SicunetWeb.Cardholder.InputPart() at SicunetWeb.Cardholder.Page_Load() at
System.Reflection.RuntimeMethodInfo.InternalInvoke() at
System.Reflection.RuntimeMethodInfo.InternalInvoke() at
System.Reflection.RuntimeMethodInfo.Invoke() at
System.Reflection.MethodBase.Invoke() at
OpenNETCF.Web.PageHandler.xb3f6b04d8059dfba() at
OpenNETCF.Web.PageHandler.xc38db762e1d7557e() at
OpenNETCF.Web.PageHandler.ProcessRequest() at
OpenNETCF.Web.Hosting.DefaultWorkerRequest.xebe5cb88b3be6a25() at
OpenNETCF.Web.Hosting.DefaultWorkerRequest.ProcessRequest() at
OpenNETCF.Web.De?faultHttpHandler.ProcessRequest() at
OpenNETCF.Web.HttpRuntime.xebe5cb88b3be6a25() at
OpenNETCF.Web.HttpRuntime.ProcessRequest() at
OpenNETCF.Web.Server.HttpRequestListener.x54d4b26b2f8d3ec8() at
OpenNETCF.Web.Server.HttpRequestListener.x8592519136076a5e() at
System.Net.LazyAsyncResult.InvokeCallback() at WorkerThread.doWork() at
WorkerThread.doWorkI() at WorkItem.doWork() at
System.Threading.Timer.ring()
Post by Paul G. Tobey [eMVP]Post by jpkongHi,
In one Windows CE 5.0 machine,
- We are using SQL Server Compact 3.5 with Padarn web server supporting
ASP.NET 2.0
- And there is MFC C++ Application using ADO/OLEDB to use SQL Compact 3.5
I want to pre-install SQL Server Compact 3.5 in Windows CE 5.0 images, NK.BIN.
For it, how to do I?
1. I added catalog item 'Applications and Services Development > SQL Compact
SQL Compact > SQL Compact' from catalog view.
After building WinCE image, it also failed to open web pages having DB
connectivity.
After installing 'sqlce.wce5.armv4i.CAB' on the target machine, web pages
are worked properly.
You did a clean sysgen after adding that item from the catalog? You removed
SQL Mobile, if it was present in the configuration previously, before doing
this build? You can't have both SQL Mobile and SQL Compact 3.5SP1 in there
at the same time. You cleared any stored registry on the device before
trying to access the database? There are SQL Compact registry entries in
your new nk.bin and you have to be sure you're using those, not some
registry stored in flash or on a storage card.
Post by jpkong2. Without installing the 'sqlce.wce5.armv4i.CAB' file, can I use DB on web
server as copying sqlceme35.dll, sqlceqp35.dll, sqlcese35.dll files to
\Windows folder?
The registry entries for SQL Compact must be added to the registry. See
\wince500\public\sqlcompact\oak\files\sqlcompact.reg.
Post by jpkong3. In above case, are there any problem with our MFC application?
4. To make the MFC app works with ADO/OLEDB, do I have to add 'Active
Template Library' catalog item into WinCE image?
I have absolutely no idea how to use MFC with SQL Compact. Perhaps someone
else will field these questions.
Paul T.