How to Register SQLITE DLL on PocketPC

A friend is developing the PocketPC side of an application we are jointly
working on.
I am creating the Desktop side.
To be able to exchange data back and forth within this application, we are
using SQLITE as the database.
It is working GREAT on the desktop side.
And my friend is able to make it work GREAT in his development environment
on his desktop.
But when he sends the application over to his PocketPC, he must register the
DHSQLITE.DLL file.

Here is the problem.

He does not have REGSRVCE.EXE on his PocketPC.
Nor can we find it anywhere, where we can obtain/extract it from.

We have downloaded and tried the REGSVR.EXE software,
and it says it can't find the DLL file he wishes to register, which he has
definitely loaded on the PocketPC.

Does anyone have any solutions for us, please ?

We are both stymied.

Thanks in advance.

(Or recommend a relational database which WILL run on both platforms, and
which we can exchange datafiles between
the platforms....
we have tried SQLServer....can't exchange datafiles.
we have tried MSAccess.... can't run on PocketPC natively.)

Rick
Mon Mar 10 11:16:50 CDT 2008

I haven't tried this, but IIRC all regsvr does (in this case) is load the
dll and call DllRegisterServer. Should be pretty easy for you to write a
program that dynamically loads dhsqlite.dll and calls its DllRegisterServer
function.

"Gary" <Fake@fake.com> wrote in message
news:B1C3E481-B554-4C81-AC19-B5662FC604B0@microsoft.com...
>A friend is developing the PocketPC side of an application we are jointly
>working on.
> I am creating the Desktop side.
> To be able to exchange data back and forth within this application, we are
> using SQLITE as the database.
> It is working GREAT on the desktop side.
> And my friend is able to make it work GREAT in his development environment
> on his desktop.
> But when he sends the application over to his PocketPC, he must register
> the DHSQLITE.DLL file.
>
> Here is the problem.
>
> He does not have REGSRVCE.EXE on his PocketPC.
> Nor can we find it anywhere, where we can obtain/extract it from.
>
> We have downloaded and tried the REGSVR.EXE software,
> and it says it can't find the DLL file he wishes to register, which he has
> definitely loaded on the PocketPC.
>
> Does anyone have any solutions for us, please ?
>
> We are both stymied.
>
> Thanks in advance.
>
> (Or recommend a relational database which WILL run on both platforms, and
> which we can exchange datafiles between
> the platforms....
> we have tried SQLServer....can't exchange datafiles.
> we have tried MSAccess.... can't run on PocketPC natively.)

Gary
Tue Mar 11 10:03:22 CDT 2008

Rick, thanks for the reply.
So, we have no idea how to do what you have suggested.
Any tips, tricks, hints, or examples you can point us at ?

Thanks


"Rick C" <pixelcat@hotmail.example.com> wrote in message
news:eyoZgpsgIHA.4164@TK2MSFTNGP05.phx.gbl...
>I haven't tried this, but IIRC all regsvr does (in this case) is load the
>dll and call DllRegisterServer. Should be pretty easy for you to write a
>program that dynamically loads dhsqlite.dll and calls its DllRegisterServer
>function.
>
> "Gary" <Fake@fake.com> wrote in message
> news:B1C3E481-B554-4C81-AC19-B5662FC604B0@microsoft.com...
>>A friend is developing the PocketPC side of an application we are jointly
>>working on.
>> I am creating the Desktop side.
>> To be able to exchange data back and forth within this application, we
>> are using SQLITE as the database.
>> It is working GREAT on the desktop side.
>> And my friend is able to make it work GREAT in his development
>> environment on his desktop.
>> But when he sends the application over to his PocketPC, he must register
>> the DHSQLITE.DLL file.
>>
>> Here is the problem.
>>
>> He does not have REGSRVCE.EXE on his PocketPC.
>> Nor can we find it anywhere, where we can obtain/extract it from.
>>
>> We have downloaded and tried the REGSVR.EXE software,
>> and it says it can't find the DLL file he wishes to register, which he
>> has definitely loaded on the PocketPC.
>>
>> Does anyone have any solutions for us, please ?
>>
>> We are both stymied.
>>
>> Thanks in advance.
>>
>> (Or recommend a relational database which WILL run on both platforms, and
>> which we can exchange datafiles between
>> the platforms....
>> we have tried SQLServer....can't exchange datafiles.
>> we have tried MSAccess.... can't run on PocketPC natively.)
>
>

Mike
Tue Mar 11 11:24:24 CDT 2008


"Gary" <Fake@fake.com> wrote in message
news:8040DFDF-F65D-45C1-8577-A6DF3FA11B58@microsoft.com...
> Rick, thanks for the reply.
> So, we have no idea how to do what you have suggested.
> Any tips, tricks, hints, or examples you can point us at ?
>
> Thanks

Can we do an inital sanity check that you are trying to install the ARM
version of the sqlite DLL's to the PDA?

The x86 version compiled for the PC will NOT work on the PDA.

I have used System.Data.SQLite[http://sqlite.phxsoftware.com/] from .NET CF
before, but it claims that it works from unmanaged code... It might be worth
a look...

Mike

Rick
Tue Mar 11 14:10:19 CDT 2008

> Can we do an inital sanity check that you are trying to install the ARM
> version of the sqlite DLL's to the PDA?
>
> The x86 version compiled for the PC will NOT work on the PDA.

Mike, while that is usually a good thing to check for, IIRC he originally
said he couldn't find regsvr32 on the handheld.

Gary, the short answer to your last post is that you use LoadLibrary, then
GetProcAddress, then call DllRegisterServer via the function pointer you got
from GetProcAddress. I don't have any sample code handy but you should be
able to figure it out from the Windows SDK docs.

Gary
Tue Mar 11 21:12:40 CDT 2008

Mike,
that is the version of SQLite we have installed and are using.
It works great on the desktop, and supposedly works on the PDA too.
But we can't get that damed dll registered on the PDA.

Gary

"Mike Hudgell" <mike.hudgell@news.etiltd.co.uk> wrote in message
news:ueMogR5gIHA.4164@TK2MSFTNGP05.phx.gbl...
>
> "Gary" <Fake@fake.com> wrote in message
> news:8040DFDF-F65D-45C1-8577-A6DF3FA11B58@microsoft.com...
>> Rick, thanks for the reply.
>> So, we have no idea how to do what you have suggested.
>> Any tips, tricks, hints, or examples you can point us at ?
>>
>> Thanks
>
> Can we do an inital sanity check that you are trying to install the ARM
> version of the sqlite DLL's to the PDA?
>
> The x86 version compiled for the PC will NOT work on the PDA.
>
> I have used System.Data.SQLite[http://sqlite.phxsoftware.com/] from .NET
> CF before, but it claims that it works from unmanaged code... It might be
> worth a look...
>
> Mike
>

Christopher
Tue Mar 11 22:32:17 CDT 2008

Hi,

"Gary" <Fake@fake.com> wrote in message
news:55ACECDA-7CFB-45A1-9781-1CE9AF9FEF3D@microsoft.com...
> that is the version of SQLite we have installed and are using.
> It works great on the desktop, and supposedly works on the PDA too.
> But we can't get that damed dll registered on the PDA.

Just searching for the phrase dhSQLite in a search engine came across this
page http://www.thecommon.net/2.html. Is this the product you are trying to
use?

If so this possibly explains some of the confusion. The core SQLite database
engine has been ported to Windows CE (and hence Windows Mobile PDAs) however
dhSQLite appears to be a COM based wrapper over top of this engine and
appears to only support desktop PCs.

Either way you need to find a PDA specific build of the database product you
are trying to use. If it supports desktop and PDA usage, there should be two
different installations/downloads for the product.

There are many differences such as CPU architectures etc between PDAs and
Desktop PCs which mean you can't use the installer for one platform on
another.

Hope this helps,
Christopher Fairbairn

Gary
Wed Mar 12 10:07:37 CDT 2008

And hello to you too.

Here is a link to the page which states that the product we have selected
works on
Full and Compact .NET Framework.

http://sqlite.phxsoftware.com/readme.htm

I quote from that page...

# Supports the Full and Compact .NET Framework, as well as native C/C++
development. 100% binary compatible with the original sqlite3.dll.
# On the Compact Framework, it is faster than the newly-introduced Sql
Server Mobile. SQLite's installed size is a fraction of Sql Mobile's. It
uses less memory at runtime, runs queries faster, and has a smaller database
file size as well.

So, we thought this was the tool to use.
Perhaps we are wrong ????

Thanks


"Christopher Fairbairn" <christopher@christec.co.nz> wrote in message
news:%2353YlG$gIHA.1208@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> "Gary" <Fake@fake.com> wrote in message
> news:55ACECDA-7CFB-45A1-9781-1CE9AF9FEF3D@microsoft.com...
>> that is the version of SQLite we have installed and are using.
>> It works great on the desktop, and supposedly works on the PDA too.
>> But we can't get that damed dll registered on the PDA.
>
> Just searching for the phrase dhSQLite in a search engine came across this
> page http://www.thecommon.net/2.html. Is this the product you are trying
> to use?
>
> If so this possibly explains some of the confusion. The core SQLite
> database engine has been ported to Windows CE (and hence Windows Mobile
> PDAs) however dhSQLite appears to be a COM based wrapper over top of this
> engine and appears to only support desktop PCs.
>
> Either way you need to find a PDA specific build of the database product
> you are trying to use. If it supports desktop and PDA usage, there should
> be two different installations/downloads for the product.
>
> There are many differences such as CPU architectures etc between PDAs and
> Desktop PCs which mean you can't use the installer for one platform on
> another.
>
> Hope this helps,
> Christopher Fairbairn
>

Christopher
Thu Mar 13 02:17:28 CDT 2008

Hi Gary,

Gary wrote:
> Here is a link to the page which states that the product we have
> selected works on Full and Compact .NET Framework.
>
> http://sqlite.phxsoftware.com/readme.htm

That project does indeed seem to support the .NET Compact Framework but
only provides an assembly called System.Data.SQLite.dll

Where is DHSQLITE.DLL coming into the picture (as mentioned in your
original posting)? It is this second dll that I think may not support
Windows CE devices.

SQLite definitely does support Windows CE and is fairly easy to get going.


Hope this helps,
Christopher Fairbairn

jmorris
Thu Mar 13 13:45:34 CDT 2008

We use Sqlite3 via dll on PocketPc 2003 SE and WinMoble 5 via C++
(wxWidgets) and are very happy with it. Don't know anything about
DHSQLITE.DLL.

However, you can do a simple check to ensure that the DLL is for ARM.
On the desktop use dependency walker on DHSQLITE.dll. Itshould
indicate a mahine type mismatch but continue on to show the implicitly
loaded DLLs. Check that all your dependencies exist and that the the
COM registration entry function exists. The machine type should show
as unknown.


On Mar 13, 12:17 am, Christopher Fairbairn
<christop...@christec.co.nz> wrote:
> Hi Gary,
>
> Gary wrote:
> > Here is a link to the page which states that the product we have
> > selected works on Full and Compact .NET Framework.
>
> >http://sqlite.phxsoftware.com/readme.htm
>
> That project does indeed seem to support the .NET Compact Framework but
> only provides an assembly called System.Data.SQLite.dll
>
> Where is DHSQLITE.DLL coming into the picture (as mentioned in your
> original posting)? It is this second dll that I think may not support
> Windows CE devices.
>
> SQLite definitely does support Windows CE and is fairly easy to get going.
>
> Hope this helps,
> Christopher Fairbairn

Gary
Tue Mar 25 10:21:40 CDT 2008

Sorry for taking so long to respond... too much to do and so little time.
Anyway, I must REVISE my original posting....
DHSQLITE.dll is the dll I use on the desktop.
But SQLITE3.dll is the dll provided for the PocketPC.

Here is a line of code we must use to make the connection

Dim dbdata4 As New SQLiteConnection

Does this suggest we might be screwing things up and NOT using the correct
DLL ?

Thanks


<jmorris@bearriver.com> wrote in message
news:3845f7da-d4e0-499e-b208-e6a9a95ff0d5@e10g2000prf.googlegroups.com...
> We use Sqlite3 via dll on PocketPc 2003 SE and WinMoble 5 via C++
> (wxWidgets) and are very happy with it. Don't know anything about
> DHSQLITE.DLL.
>
> However, you can do a simple check to ensure that the DLL is for ARM.
> On the desktop use dependency walker on DHSQLITE.dll. Itshould
> indicate a mahine type mismatch but continue on to show the implicitly
> loaded DLLs. Check that all your dependencies exist and that the the
> COM registration entry function exists. The machine type should show
> as unknown.
>
>
> On Mar 13, 12:17 am, Christopher Fairbairn
> <christop...@christec.co.nz> wrote:
>> Hi Gary,
>>
>> Gary wrote:
>> > Here is a link to the page which states that the product we have
>> > selected works on Full and Compact .NET Framework.
>>
>> >http://sqlite.phxsoftware.com/readme.htm
>>
>> That project does indeed seem to support the .NET Compact Framework but
>> only provides an assembly called System.Data.SQLite.dll
>>
>> Where is DHSQLITE.DLL coming into the picture (as mentioned in your
>> original posting)? It is this second dll that I think may not support
>> Windows CE devices.
>>
>> SQLite definitely does support Windows CE and is fairly easy to get
>> going.
>>
>> Hope this helps,
>> Christopher Fairbairn
>

jmorris
Wed Mar 26 12:55:34 CDT 2008

Gary,

Out of curiosity I just downloaded SQLite-1.0.48.0-binaries.zip and
SQLite-1.0.48.0-source.zip. I haven't done anything with these but
noticed that there is a testce.exe and associated project. Did these
run corrrectly?