Hi,

Anyone knows how to register a Dll for WinCe?
Can it be done from a Lazarus App?

Regards,

- Leslie -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20080613/61b8275f/attachment-0001.html

2008/6/13 :

Anyone knows how to register a Dll for WinCe? Can it be done from a Lazarus App?

Define "register a dll"

Define "register a dll"

I am trying to make an app based on a SQLlite database. When the program is loading it does not find the sqlite3.dll, though it is in the same dir and it is the right build (for WinCE).

After some googling it seems that it is not enough simply to copy the dll to the application directory, WinCe needs to be told it is there.

Does this clear the picture?

- Leslie -

Just need to copy to you exe path, there is no register for sqlite3sll. I think the problem is version of your sqlite3.dll and Lazarus try to search in the forums to find the correct answers, some one there have the same problem.

The Win32 Dll is v3.59, the WinCe version is v3.56. Could this be the problem?

- Leslie -

As i remember 3.2.2 for wince
try http://sourceforge.net/project/showfiles.php?group_id=88393

Is 3.2.2 the version you have been using in your apps? If it is, is there any problem I better be aware of?

Generally the latest version (if it is not new major version) should be more stable. This is the latest I have found :
http://www.ap-i.net/pub/sqlite/.

Have you tried to compile Sqlite from source?

Thanks for your help!

- Leslie -

Sqlite wince project is obsolete, the wince code is now merged in the main sqlite.
You can get the latest version source from sqlite.org and compile for wince. I have put here the version I use for my project, arm binary, source and visual studio project:
http://www.ap-i.net/pub/sqlite/
To use the library just copy to the same directory as the exe and LoadLibrary((sqlite3.dll) work without problem.

Oops, not see in last message you already use my file :) Try just the LoadLibrary in a simple project to be sure if this is the problem.

Oh, it was you then. I enjoy these little surprises of life. :) Thanks for making the binary WinCe version of SQLite available! I have no idea why the official site does not offer it. If it is not too much trouble could you please upload the latest version too? :) Looking at your comments in the source, you have done some preparation with the source to make a more optimized compilation possible. This obviously takes some time, but I'd be more then happy even without that. But feel absolutely free to ignore my asking, if you decide not to. :)

The problem has disappeared, though I am not quite sure exactly how. After restarting the PDA emulator and rebuilding the app with fpc 2.2.3 it suddenly started working.

Though I still have a few questions regarding SQLite/WinCe, where you might be able to enlighten me.

1. How do you connect to the SQLite db? (I have tried to use the Lazarus SQLite components, and there is no problem with opening the connection any more, but even a simple select query have failed to open. The same source compiled for Win32 works ok, and the db path is not the problem.)

Zaher has made a nice library - it is the only available working solution I know of - but it is not dbaware, so the controls needs to be connected manually. I would like to know if there are other worthy choices out there.

2. Similar situation with printing .Any solution you would recommend for printing from a WinCe app?

3. Maybe you could advice me how to set up the necessary tools to do the compilation myself.

- Leslie -

The problem has disappeared, though I am not quite sure exactly how. After restarting the PDA emulator and rebuilding the app with fpc 2.2.3 it suddenly started working.

There is a SQlite function used by old FPC not found in SQlite for WINCe already found in Sqlite for Win32.

Zaher has made a nice library - it is the only available working solution I know of - but it is not dbaware, so the controls needs to be connected manually. I would like to know if there are other worthy choices out there.

I hate dbaware :) after move to new generation of databases Firbeird/Sqlite/Postgre
I like to send command and receive the result then process it in the forms.

2. Similar situation with printing .Any solution you would recommend for printing from a WinCe app?

You can search for Printing on WinCE over internet, i think you will find some article about it, my solution is use COM to send ESC/POS command because most of Printers support this protocol.

Op vrijdag 13-06-2008 om 15:40 uur [tijdzone +0200], schreef :

Only a few dll need registering, and I used the sqlite3.dll without registering by placing it in the same directory as the application. so I guess your problem is something else.

Joost.

if it is not too much trouble could you please upload the latest version too? :)

Yes this is possible but I need to boot on Windows for that and this is not very frequent :)

1. How do you connect to the SQLite db?

I use libsql ( http://sourceforge.net/projects/libsql ) since some time because I know it quiet well by participating to the devel. since Kylix port. But I am not sure I would recommend you start with it now, maybe better to try to use directly a FPC TSqlite3Dataset. I also not like to work with dbaware component and always use queries in code because it is very infrequent I have to display data without some processing. It's ok for address book like application but this is not what I do.

2. Similar situation with printing

Sorry, I not use printing with wince.

3. Maybe you could advice me how to set up the necessary tools to do the compilation myself.

I use Visual Studio with a license I have from work, the project file is include with the source code. I use it exclusively for this lib. Lazarus is much better for Wince development :)
I don't know a simpler solution to compile a C library for Wince, this is probably possible with GCC but I not investigate.

Thanks for your answer.

I have posted a bugreport at the forum you have suggested earlier.

- Leslie -

Oh, your machine is still infected with this rather old security risk. :)) (I am developing for the Windows platform most of the time. Though as Lazarus is maturing this might change a bit now.)

Thanks, I will take a look at it.

Is this the embedded version or the "normal" VS 2003/2005/2008?

- Leslie -