Access violation error using sqlite3 functions

[David L Morris]

Hello to you I am a new user.  I downloaded the wrsqlit3 project files and was pleased to find the included exe file ran and worked as might be expected.  When I tried to compile it with my new Pelles C version 6.00.4, the compile does not work and displays the following:-

Building main.obj.
Building main.res.
Building wrsqlit3.exe.
POLINK: error: Unresolved external symbol '_sqlite3_open@8'.
POLINK: error: Unresolved external symbol '_sqlite3_close@4'.
POLINK: error: Unresolved external symbol '_sqlite3_malloc@4'.
POLINK: error: Unresolved external symbol '_sqlite3_exec@20'.
POLINK: error: Unresolved external symbol '_sqlite3_free@4'.
POLINK: error: Unresolved external symbol '_sqlite3_errcode@4'.
POLINK: error: Unresolved external symbol '_sqlite3_errmsg@4'.
POLINK: fatal error: 7 unresolved external(s).
*** Error code: 1 ***
Done.

In hope you might be able to help?  I have been using PowerBasic to successfully work on SQLite3. Now I am retired I want to relearn the  C language.

Thanks  David

[Stefan Pendl]

There are several threads dealing with this problem, so please try searching for "sqlite" to get the resolution.

[David L Morris]

Ok Stefan, my search for sqlite seems to only present this complete thread. I made changes to the Sqlite3.h file and it still doesn't compile but the errors showing are as below so I would appreciate any more guidance.

Building wrsqlit3.exe.
POLINK: error: Unresolved external symbol '_sqlite3_malloc@4'.
POLINK: error: Unresolved external symbol '_sqlite3_free@4'.
POLINK: error: Unresolved external symbol '_sqlite3_errmsg@4'.
POLINK: fatal error: 3 unresolved external(s).
*** Error code: 1 ***
Done.

[frankie]

The error you get clearly declare that the missing functions are expected to be __stdcall (as highlited from the presence of decorations), but the sqlite3 libraries and DLL are __cdecl.
This means that you haven't modified correctly the sqlite3.h adding __cdecl attribute at each function declaration as explained in many threads on this issue (as Stefan said).
Please make the required corrections and also read better the threads so you will find also the sqlite3.h file correctly updated.

[David L Morris]

Thanks frankie. I have just corrected what I think are the last changes and it compiles OK.  I added a word to the dialog caption and that shows up correctly in the compiled exe.  Now I can try some actual development, so no doubt I will be back for help as time proceeds.
Regards
David

[David L Morris]

I see that for each project in pelles C, an Sqlite3 database file (*.tag) is created with a browse table in the project folder.  That is interesting to me and gives an endorsement to the quality of the Sqlite database. I would appreciate any comment on this?

David

[Robert]

I see that for each project in pelles C, an Sqlite3 database file (*.tag) is created with a browse table in the project folder.  That is interesting to me and gives an endorsement to the quality of the Sqlite database. I would appreciate any comment on this?

David

The quality is obvious from the implicit endorsement by many famous users. For details please see

http://www.sqlite.org/famous.html

Robert Wishlaw