Integration of SQLite Database With Native Visual C++ Application

Here is the way to Integrate SQLite Database with Visual C++ or Visual studio for win32 console application. I hope you find this helpful!!!!

• Create a new C++ Win32 Console application.

• Download the native SQLite DLL from:http://www.sqlite.org/2014/sqlite-dll-win32-x86-3080704.zip.

• Unzip the DLL and DEF files.

• Place .DEF file into project’s source folder.

• Place sqlite3.dll  in a System32 Folder.

• Open a “Visual Studio Command Prompt (2010)” and change directory to your project source folder.

• Create an import library using the following command line: LIB /DEF:sqlite3.def

• Add the library i.e. sqlite3.lib to your working project. 

• Goto Project Properties -> Configuration Properties -> Linker -> Additional Dependencies.

• Download source and header files from http://www.sqlite.org/snapshot/sqlite-amalgamation-2014121600020.zip

• Unzip the sqlite3.h header file and place into your source directory.

• Include the the sqlite3.h header file in your source code.