16

I've got this MFC application I'm working on that needs to have an embedded database. So I went hunting for a slick, fast "embeddable" database for it and stumbled accross SQLite.

I created a DB with it, and I created a static library project with Visual Studio 2008. the library project will be used in another main project.

In the library project, I created a class DBClass with a method AddFeedToDB(CFeed f). The library project uses the .lib file from codeproject (cppsqlite3.lib).

When compiling the static library, no error is detected, but when I try to use the library project file in the main project, I get these type of errors:

error LNK2019: unresolved external symbol "public:void __thiscall
   CppSQLite3DB::close(void)" (?close@CppSQLite3DB@@QAEXXZ 
   referenced in function "public: int __thiscall
   CTalkingFeedsDB::AddFeedToDB(class CFeed,char const*)" (?
   AddFeedToDB@CTalkingFeedsDB@@QAEHVCFeed@@PDB@Z

What am I missing?

Jason Plank
  • 2,336
  • 5
  • 31
  • 40
Attilah
  • 17,632
  • 38
  • 139
  • 202

6 Answers6

15

I know it is already 2 years since this question... but i run in the same situation here. Added all the header files... added the lib directories.. and keep having this error. So i added manually the lib to the Configuration Properties -> Linker -> Input -> Aditional Dependencies and all works for me.

Luis Eduardo
  • 151
  • 1
  • 2
9

It happened to me more than once that I thought symbol XXX (i.e. ?close@CppSQLite3DB@@QAEXXZ) was in the import lib, while the actual symbol was __impXXX (i.e. __imp?close@CppSQLite3DB@@QAEXXZ).

The reason for the linker error is then to be found in the compilation step: the compiler will generate the ?close@CppSQLite3DB@@QAEXXZ symbol to be imported, where it should generate __imp?close@CppSQLite3DB@@QAEXXZ. This often means that the function declaration itself didn't have __declspec( dllimport ). Which may be caused by some preprocessor symbol not being defined. Or the __declspec not being there at all...

Jason Plank
  • 2,336
  • 5
  • 31
  • 40
xtofl
  • 40,723
  • 12
  • 105
  • 192
  • Does this answers into given question? – ST3 Oct 15 '13 at 09:19
  • @ST3: apparently, it solved this particular case. It's not a general recipe for solving linker errors, if that's what you mean. – xtofl Oct 16 '13 at 18:20
  • Yes, adding this line solved my (similar) problem too. What is actually happen is that some project needs a symbol defined in another dll which is not exported (typically MSVS) – mr_T Oct 08 '14 at 11:24
4

Don't know if it is your case, but the imp prefix may mean that you are compiling a x64 library in a Win32 project.

Ago
  • 217
  • 3
  • 3
1

You either need to link the codeproject SQLite lib to your executable, or to include the sources files in your project directly. (Which one did you do ?)

MickaelFM
  • 897
  • 1
  • 8
  • 19
  • 2
    in the library project, i went to project->properties->Configuration Properties->Librarian->General->Additional Dependencies and I added "..\SQLiteCommon\sqlite3.lib" to it. – Attilah May 11 '09 at 18:06
  • Did you link it statically (as you compiled it) ? – MickaelFM May 11 '09 at 18:11
  • yes, i linked it statically, i think. but wht's weird is that as in other project types, i don't see a Linker tab in Project Properties->Configuration properties, but i see Librarian instead. – Attilah May 11 '09 at 18:48
1

I would follow these steps:

  1. think about what library or .obj file you expect the symbol to be exported by.

  2. check whether it actually does export that very symbol (check character-wise). Sometimes, it's the calling convention differs.

  3. check if the library you expect to contain the symbol is known to the linker - first check for the 'additional libraries', then check if the library is actually found (I mostly do this by using filemon.exe from sysinternals, and look for link.exe to open the lib file. )

After thinking a while, you may find that your library project will not export the sought for function. That function is in the database lib. You should add that lib to your main project. It's no use adding it to your static lib project.

xtofl
  • 40,723
  • 12
  • 105
  • 192
  • the lib(sqlite.lib) does export the symbols. i added the lib to my main project, still it doesn't work. i still get the same errors. – Attilah May 12 '09 at 13:17
1

The compiler and linker will not link one library into another (unless one is a DLL). You need to specify both libraries (cppsqlite3.lib and your own static library) in your main project.

Mark Ransom
  • 299,747
  • 42
  • 398
  • 622