Legacy header files

[ander_cc]

There are two header files in folder "Include/win/winsqlite/": winsqlite3.h and winsqlite3ext.h.
But no related .lib files are included in folder "Lib".
Is this a deprecated feature?

[John Z]

Hi ander_cc,

There are two windows system dll's that might help -

C:\windows\system32\winsqlite3.dll
and
C:\windows\SysWOW64\winsqlite3.dll

John Z

[TimoVJL]

winsqlite3.dll is available since Windows 10 ?

[ander_cc]

Hi ander_cc,

There are two windows system dll's that might help -

C:\windows\system32\winsqlite3.dll
and
C:\windows\SysWOW64\winsqlite3.dll

John Z

I see, thank you very much! I find the dll. But how to use it?

[John Z]

Well I'm far from an expert but I have used a dll in a program.
basically the use follows this:
1)LoadLibrary: Loads the DLL into memory.
2)repeat GetProcAddress: Get a pointers to the exported functions.
3)use the functions:
4)FreeLibrary: Unloads the DLL when done.

A quick web example where the dll contains 1 function:
__declspec(dllexport) int Add(int a, int b) {return a + b};

Code Select Expand


// LoadDLL.c
#include <windows.h>
#include <stdio.h>

typedef int (*AddFunc)(int, int);

int main() {
    HMODULE hDll = LoadLibrary(TEXT("ExampleDLL.dll"));
    if (hDll == NULL) {
        printf("Failed to load DLL. Error: %d\n", GetLastError());
        return 1;
    }

    AddFunc add = (AddFunc)GetProcAddress(hDll, "Add");
    if (add == NULL) {
        printf("Failed to get function. Error: %d\n", GetLastError());
        FreeLibrary(hDll);
        return 1;
    }

    int result = add(2, 3);
    printf("2 + 3 = %d\n", result);

    FreeLibrary(hDll);
    return 0;
}

some code excerpts from one of my actual programs

Code Select Expand

// Load the dll

  swprintf(p_DllFile,260,L"%ls%ls",p_appdir, L"libxlsxio_write64.dll" );
  hXlsxLib = LoadLibrary(p_DllFile);
  if (hXlsxLib == NULL)
    { MessageBoxA(NULL,"Can't export because the DLL is missing.","XLSX Export",MB_OK|MB_ICONERROR);
      return;
}

// get the functions

/* set up DLL procs */
(FARPROC) add_cell_datetime  = GetProcAddress(hXlsxLib,"xlsxiowrite_add_cell_datetime") ;
(FARPROC) add_cell_float     = GetProcAddress(hXlsxLib,"xlsxiowrite_add_cell_float") ;
(FARPROC) add_cell_int       = GetProcAddress(hXlsxLib,"xlsxiowrite_add_cell_int") ;
(FARPROC) add_cell_string    = GetProcAddress(hXlsxLib,"xlsxiowrite_add_cell_string")  ;
(FARPROC) add_column         = GetProcAddress(hXlsxLib,"xlsxiowrite_add_column") ;
(FARPROC) write_close        = GetProcAddress(hXlsxLib,"xlsxiowrite_close") ;
(FARPROC) get_version        = GetProcAddress(hXlsxLib,"xlsxiowrite_get_version") ;
(FARPROC) get_version_string = GetProcAddress(hXlsxLib,"xlsxiowrite_get_version_string") ;
(FARPROC) next_row           = GetProcAddress(hXlsxLib,"xlsxiowrite_next_row") ;
(FARPROC) write_open         = GetProcAddress(hXlsxLib,"xlsxiowrite_open") ;
(FARPROC) set_detection_rows = GetProcAddress(hXlsxLib,"xlsxiowrite_set_detection_rows") ;
(FARPROC) set_row_height     = GetProcAddress(hXlsxLib,"xlsxiowrite_set_row_height") ;

 // use the exported function
 .....
 
// finally clean up
  // release DLL
  FreeLibrary(hXlsxLib) ;

Hopefully helpful, at least a start -

John Z

[ander_cc]

Well I'm far from an expert but I have used a dll in a program.
basically the use follows this:
1)LoadLibrary: Loads the DLL into memory.
2)repeat GetProcAddress: Get a pointers to the exported functions.
3)use the functions:
4)FreeLibrary: Unloads the DLL when done.

A quick web example where the dll contains 1 function:
__declspec(dllexport) int Add(int a, int b) {return a + b};

some code excerpts from one of my actual programs

Hopefully helpful, at least a start -

John Z

Many thanks for your detailed explanation. I will try.

[TimoVJL]

With simple example might be possible to check imports

Code Select Expand

#include <stdio.h>
#include <stdlib.h>
//#include "sqlite3.h"
#include <winsqlite/winsqlite3.h>

#pragma comment(lib, "SQLite3.lib")

int __cdecl main(int argc, char **argv)
{
sqlite3 *db;
int rc;
char *szSQL =
"DROP TABLE IF EXISTS test;"
"CREATE TABLE IF NOT EXISTS test (id INTEGER NOT NULL PRIMARY KEY, text VARCHAR(100));"
"INSERT INTO test VALUES (1, 'text1');"
"SELECT * FROM test;";
char *pSQL1, *pSQL2;


rc = sqlite3_open("test.db3", &db);
if (rc == SQLITE_OK)
{
sqlite3_stmt *stmt;
pSQL1 = szSQL; // at start
do
{
rc = sqlite3_prepare_v2(db, pSQL1, -1, &stmt, (const char**)&pSQL2);
if (rc == SQLITE_OK)
{
int nCols = sqlite3_column_count(stmt);
if (nCols)
{
int nCol;
for (nCol = 0; nCol < nCols; nCol++)
printf("%s\t", sqlite3_column_name(stmt, nCol));
printf("\n");
while ((rc = sqlite3_step(stmt)) == SQLITE_ROW)
for (nCol = 0; nCol < nCols; nCol++)
printf("%s\t", sqlite3_column_text(stmt, nCol));
printf("\n");
}
sqlite3_finalize(stmt);
} else {
fprintf(stderr, "Error: %s\n", sqlite3_errmsg(db));
break;
}
pSQL1 = pSQL2; // next statement
} while (*pSQL2);
sqlite3_close(db);
} else {
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
return 1;
}
return 0;
}
after that just use polib.exe to create import library.
If functions are cdecl., just use polib with dll.

[Vortex]

Hi ander_cc,

Can you check this GitHub account?

https://github.com/buggins/ddbc/tree/master/libs

sqlite3.lib :

https://github.com/buggins/ddbc/tree/master/libs/win32

https://github.com/buggins/ddbc/tree/master/libs/win64

[John Z]

Hi ander_cc,

A lot of help now 👍👍👍

You can also find the exported functions using:
 C:\Program Files\PellesC\Bin\pope.exe

Attached example shows part of the output for the winsqlite3.dll, copy paste not possible so image is attached.

John Z

[Robert]

There are two header files in folder "Include/win/winsqlite/": winsqlite3.h and winsqlite3ext.h.
But no related .lib files are included in folder "Lib".
Is this a deprecated feature?

I suspect that Pelle did not include the .lib files for those .dlls because there was a security vulnerability.

https://learn.microsoft.com/en-us/answers/questions/5591853/vulnerability-in-winsqlite3-dll