Trying to compile a std_call dll to be used with VB6 and VBA.
Using instructions and files from this website:
https://sqliteforexcel.codeplex.com/
All works well and have added a few SQLite functions that weren't in the
compiled dll
as in the download section from that website.
However having problems adding sqlite3_db_filename.
I added this to sqlite3.h:
const char *sqlite3_db_filename(sqlite3 *db, const char *zDbName);
and this to SQLite3_StdCall.c:
SQLITE3_STDCALL_API const char * __stdcall
sqlite3_stdcall_db_filename(sqlite3 *pDb, const char *zDbName)
{
return sqlite3_db_filename(pDb, zDbName);
}
It doesn't compile and gives linking errors:
Error 1 error LNK2001: unresolved external symbol
_sqlite3_db_filename
C:\Users\Bart\SQLiteForExcel\Source\SQLite3_StdCall\SQLite3_StdCall.obj
SQLite3_StdCall
Error 2 error LNK1120: 1 unresolved
externals
C:\Users\Bart\SQLiteForExcel\Source\SQLite3_StdCall\Release\SQLite3_StdCall.dll
1 1 SQLite3_StdCall
Strangely it doesn't point to a line in the block SQLITE3_STDCALL_API but
points to line 1.
This is at the start of SQLite3_StdCall.c:
#include "stdafx.h"
#include "SQLite3_StdCall.h"
Compiling this on Windows 7 with Microsoft Visual Studio Professional
Studio 2013.
Admittedly, don't know anything about C or C++ or compiling C code, so I am
sure I must
be overlooking something simple and silly, but just can't figure it out.
Any ideas what could be the problem here?
RBS
