Sqlite3 install error - Win 10

Hi All,

I have an issue trying to install the sqlite3 gem using Ruby on Rails 3.0.1.

Using Windows 10 21H2 x64. The SQLite engine is installed.

Below is the error message from “C:/Ruby30-x64/lib/ruby/gems/3.0.0/extensions/x64-mingw32/3.0.0/sqlite3-1.4.2/mkmf.log”

“x86_64-w64-mingw32-gcc -o conftest.exe -IC:/Ruby30-x64/include/ruby-3.0.0/x64-mingw32 -IC:/Ruby30-x64/include/ruby-3.0.0/ruby/backward -IC:/Ruby30-x64/include/ruby-3.0.0 -I. -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64 -O3 -fno-fast-math -fstack-protector-strong conftest.c -L. -LC:/Ruby30-x64/lib -L. -pipe -s -fstack-protector-strong -m64 -lpthread -lx64-msvcrt-ruby300 -lsqlite3 -lpthread -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi " C:/Ruby30-x64/msys64/mingw64/bin/…/lib/gcc/x86_64-w64-mingw32/10.2.0/…/…/…/…/x86_64-w64-mingw32/bin/ld.exe: cannot find -lsqlite3 collect2.exe: error: ld returned 1 exit status checked program was: /* begin / 1: #include “ruby.h” 2: 3: #include <winsock2.h> 4: #include <windows.h> 5: 6: /top/ 7: extern int t(void); 8: int main(int argc, char *argv) 9: { 10: if (argc > 1000000) { 11: int ( volatile tp)(void)=(int ()(void))&t; 12: printf(”%d", (tp)()); 13: } 14: 15: return !!argv[argc]; 16: } 17: extern void sqlite3_libversion_number(); 18: int t(void) { sqlite3_libversion_number(); return 0; } / end */