in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Linking SQLite.Interop fails for 1.0.60.0

Last post 12-03-2008 9:18 AM by Robert Simpson. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 10-28-2008 11:01 AM

    Linking SQLite.Interop fails for 1.0.60.0

     Hello,

     Trying to build the SQLite.Interop project in the VS2K8 project fails at linking with a whole bunch of errors.

     

    • Error    1    error LNK2005: sqlite3_api already defined in fts3_tokenizer.obj    rtree.obj    SQLite.Interop
    • Error    2    error LNK2019: unresolved external symbol sqlite3PcacheSetCachesize referenced in function sqlite3PagerSetCachesize    interop.obj    SQLite.Interop
    • Error    3    error LNK2019: unresolved external symbol sqlite3PcacheOpen referenced in function sqlite3PagerOpen    interop.obj    SQLite.Interop
    • Error    4    error LNK2019: unresolved external symbol sqlite3PageMalloc referenced in function sqlite3PagerOpen    interop.obj    SQLite.Interop
    • Error    5    error LNK2001: unresolved external symbol sqlite3PageMalloc    btree.obj    SQLite.Interop
    • Error    6    error LNK2019: unresolved external symbol sqlite3PcacheSize referenced in function sqlite3PagerOpen    interop.obj    SQLite.Interop
    • Error    7    error LNK2019: unresolved external symbol sqlite3PcacheSetPageSize referenced in function sqlite3PagerSetPagesize    interop.obj    SQLite.Interop
    • Error    8    error LNK2019: unresolved external symbol sqlite3PageFree referenced in function sqlite3PagerSetPagesize    interop.obj    SQLite.Interop
    • Error    9    error LNK2001: unresolved external symbol sqlite3PageFree    btree.obj    SQLite.Interop
    • Error    10    error LNK2019: unresolved external symbol sqlite3PcacheRefCount referenced in function sqlite3PagerSetPagesize    interop.obj    SQLite.Interop
    • Error    11    error LNK2019: unresolved external symbol sqlite3PcacheClear referenced in function pager_reset    interop.obj    SQLite.Interop
    • Error    12    error LNK2019: unresolved external symbol sqlite3PcacheTruncate referenced in function pager_truncate_cache    interop.obj    SQLite.Interop
    • Error    13    error LNK2019: unresolved external symbol sqlite3PcacheClose referenced in function sqlite3PagerClose    interop.obj    SQLite.Interop
    • Error    14    error LNK2019: unresolved external symbol sqlite3PcacheRef referenced in function sqlite3PagerRef    interop.obj    SQLite.Interop
    • Error    15    error LNK2019: unresolved external symbol sqlite3PcacheAssertFlags referenced in function syncJournal    interop.obj    SQLite.Interop
    • Error    16    error LNK2019: unresolved external symbol sqlite3PcacheClearFlags referenced in function syncJournal    interop.obj    SQLite.Interop
    • Error    17    error LNK2019: unresolved external symbol sqlite3PcacheMakeClean referenced in function pagerStress    interop.obj    SQLite.Interop
    • Error    18    error LNK2019: unresolved external symbol sqlite3PcacheFetch referenced in function sqlite3PagerAcquire    interop.obj    SQLite.Interop
    • Error    19    error LNK2019: unresolved external symbol sqlite3PcachePagecount referenced in function pagerSharedLock    interop.obj    SQLite.Interop
    • Error    20    error LNK2019: unresolved external symbol sqlite3PcacheCleanAll referenced in function pager_end_transaction    interop.obj    SQLite.Interop
    • Error    21    error LNK2019: unresolved external symbol sqlite3PcacheRelease referenced in function pager_playback_one_page    interop.obj    SQLite.Interop
    • Error    22    error LNK2019: unresolved external symbol sqlite3PcacheDrop referenced in function pagerDropPage    interop.obj    SQLite.Interop
    • Error    23    error LNK2019: unresolved external symbol sqlite3PcachePreserve referenced in function pager_write    interop.obj    SQLite.Interop
    • Error    24    error LNK2019: unresolved external symbol sqlite3PcacheMakeDirty referenced in function makeDirty    interop.obj    SQLite.Interop
    • Error    25    error LNK2019: unresolved external symbol sqlite3PcacheDirtyList referenced in function sqlite3PagerCommitPhaseOne    interop.obj    SQLite.Interop
    • Error    26    error LNK2019: unresolved external symbol sqlite3PcacheCommit referenced in function sqlite3PagerCommitPhaseTwo    interop.obj    SQLite.Interop
    • Error    27    error LNK2019: unresolved external symbol sqlite3PcacheRollback referenced in function sqlite3PagerRollback    interop.obj    SQLite.Interop
    • Error    28    error LNK2019: unresolved external symbol sqlite3PcacheMove referenced in function sqlite3PagerMovepage    interop.obj    SQLite.Interop
    • Error    29    error LNK2019: unresolved external symbol sqlite3ResolveExprNames referenced in function codeTriggerProgram    trigger.obj    SQLite.Interop
    • Error    30    error LNK2001: unresolved external symbol sqlite3ResolveExprNames    update.obj    SQLite.Interop
    • Error    31    error LNK2001: unresolved external symbol sqlite3ResolveExprNames    attach.obj    SQLite.Interop
    • Error    32    error LNK2001: unresolved external symbol sqlite3ResolveExprNames    build.obj    SQLite.Interop
    • Error    33    error LNK2001: unresolved external symbol sqlite3ResolveExprNames    delete.obj    SQLite.Interop
    • Error    34    error LNK2001: unresolved external symbol sqlite3ResolveExprNames    insert.obj    SQLite.Interop
    • Error    35    error LNK2019: unresolved external symbol sqlite3WalkExpr referenced in function exprIsConst    expr.obj    SQLite.Interop
    • Error    36    error LNK2019: unresolved external symbol sqlite3WalkSelect referenced in function analyzeAggregatesInSelect    expr.obj    SQLite.Interop
    • Error    37    error LNK2001: unresolved external symbol sqlite3WalkSelect    select.obj    SQLite.Interop
    • Error    38    error LNK2019: unresolved external symbol sqlite3PCacheBufferSetup referenced in function sqlite3_initialize    main.obj    SQLite.Interop
    • Error    39    error LNK2019: unresolved external symbol sqlite3PcacheInitialize referenced in function sqlite3_initialize    main.obj    SQLite.Interop
    • Error    40    error LNK2019: unresolved external symbol sqlite3PcacheShutdown referenced in function sqlite3_shutdown    main.obj    SQLite.Interop
    • Error    41    error LNK2019: unresolved external symbol sqlite3ResolveSelectNames referenced in function sqlite3SelectPrep    select.obj    SQLite.Interop
    • Error    42    error LNK2019: unresolved external symbol sqlite3ResolveOrderGroupBy referenced in function multiSelectOrderBy    select.obj    SQLite.Interop
    • Error    43    fatal error LNK1120: 33 unresolved externals    ../bin/x64/SQLite.Interop.DLL    SQLite.Interop

     The output windows shows the following:

    1>------ Build started: Project: SQLite.Interop, Configuration: Debug x64 ------
    1>Compiling...
    1>where.c
    1>vtab.c
    1>vdbemem.c
    1>vdbefifo.c
    1>vdbeblob.c
    1>vdbeaux.c
    1>vdbeapi.c
    1>vdbe.c
    1>vacuum.c
    1>util.c
    1>utf.c
    1>update.c
    1>trigger.c
    1>tokenize.c
    1>table.c
    1>status.c
    1>select.c
    1>rtree.c
    1>random.c
    1>printf.c
    1>Generating Code...
    1>Compiling...
    1>prepare.c
    1>pragma.c
    1>parse.c
    1>os_win.c
    1>os.c
    1>opcodes.c
    1>mutex_w32.c
    1>mutex.c
    1>mem5.c
    1>mem4.c
    1>mem3.c
    1>mem2.c
    1>mem1.c
    1>malloc.c
    1>main.c
    1>loadext.c
    1>legacy.c
    1>journal.c
    1>insert.c
    1>hash.c
    1>Generating Code...
    1>Compiling...
    1>global.c
    1>func.c
    1>fts3_tokenizer1.c
    1>fts3_tokenizer.c
    1>fts3_porter.c
    1>fts3_hash.c
    1>fts3.c
    1>fault.c
    1>expr.c
    1>delete.c
    1>date.c
    1>complete.c
    1>callback.c
    1>build.c
    1>btree.c
    1>btmutex.c
    1>bitvec.c
    1>auth.c
    1>attach.c
    1>analyze.c
    1>Generating Code...
    1>Compiling...
    1>alter.c
    1>interop.c
    1>Generating Code...
    1>Compiling resources...
    1>Microsoft (R) Windows (R) Resource Compiler Version 6.0.5724.0
    1>Copyright (C) Microsoft Corporation.  All rights reserved.
    1>Compiling manifest to resources...
    1>Microsoft (R) Windows (R) Resource Compiler Version 6.0.5724.0
    1>Copyright (C) Microsoft Corporation.  All rights reserved.
    1>Linking...
    1>rtree.obj : error LNK2005: sqlite3_api already defined in fts3_tokenizer.obj
    1>   Creating library ../bin/x64/SQLite.Interop.lib and object ../bin/x64/SQLite.Interop.exp
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheSetCachesize referenced in function sqlite3PagerSetCachesize
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheOpen referenced in function sqlite3PagerOpen
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PageMalloc referenced in function sqlite3PagerOpen
    1>btree.obj : error LNK2001: unresolved external symbol sqlite3PageMalloc
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheSize referenced in function sqlite3PagerOpen
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheSetPageSize referenced in function sqlite3PagerSetPagesize
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PageFree referenced in function sqlite3PagerSetPagesize
    1>btree.obj : error LNK2001: unresolved external symbol sqlite3PageFree
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheRefCount referenced in function sqlite3PagerSetPagesize
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheClear referenced in function pager_reset
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheTruncate referenced in function pager_truncate_cache
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheClose referenced in function sqlite3PagerClose
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheRef referenced in function sqlite3PagerRef
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheAssertFlags referenced in function syncJournal
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheClearFlags referenced in function syncJournal
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheMakeClean referenced in function pagerStress
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheFetch referenced in function sqlite3PagerAcquire
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcachePagecount referenced in function pagerSharedLock
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheCleanAll referenced in function pager_end_transaction
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheRelease referenced in function pager_playback_one_page
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheDrop referenced in function pagerDropPage
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcachePreserve referenced in function pager_write
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheMakeDirty referenced in function makeDirty
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheDirtyList referenced in function sqlite3PagerCommitPhaseOne
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheCommit referenced in function sqlite3PagerCommitPhaseTwo
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheRollback referenced in function sqlite3PagerRollback
    1>interop.obj : error LNK2019: unresolved external symbol sqlite3PcacheMove referenced in function sqlite3PagerMovepage
    1>trigger.obj : error LNK2019: unresolved external symbol sqlite3ResolveExprNames referenced in function codeTriggerProgram
    1>update.obj : error LNK2001: unresolved external symbol sqlite3ResolveExprNames
    1>attach.obj : error LNK2001: unresolved external symbol sqlite3ResolveExprNames
    1>build.obj : error LNK2001: unresolved external symbol sqlite3ResolveExprNames
    1>delete.obj : error LNK2001: unresolved external symbol sqlite3ResolveExprNames
    1>insert.obj : error LNK2001: unresolved external symbol sqlite3ResolveExprNames
    1>expr.obj : error LNK2019: unresolved external symbol sqlite3WalkExpr referenced in function exprIsConst
    1>expr.obj : error LNK2019: unresolved external symbol sqlite3WalkSelect referenced in function analyzeAggregatesInSelect
    1>select.obj : error LNK2001: unresolved external symbol sqlite3WalkSelect
    1>main.obj : error LNK2019: unresolved external symbol sqlite3PCacheBufferSetup referenced in function sqlite3_initialize
    1>main.obj : error LNK2019: unresolved external symbol sqlite3PcacheInitialize referenced in function sqlite3_initialize
    1>main.obj : error LNK2019: unresolved external symbol sqlite3PcacheShutdown referenced in function sqlite3_shutdown
    1>select.obj : error LNK2019: unresolved external symbol sqlite3ResolveSelectNames referenced in function sqlite3SelectPrep
    1>select.obj : error LNK2019: unresolved external symbol sqlite3ResolveOrderGroupBy referenced in function multiSelectOrderBy
    1>../bin/x64/SQLite.Interop.DLL : fatal error LNK1120: 33 unresolved externals
    1>Build log was saved at "file://c:\var\Projects\SqLite\1.0.60.0\SQLite.Interop\x64\Debug\BuildLog.htm"
    1>SQLite.Interop - 43 error(s), 0 warning(s)
    ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

     This does not happen with 1.0.59.0.

     

  • 11-04-2008 7:31 AM In reply to

    • areel
    • Top 200 Contributor
    • Joined on 04-19-2007
    • Posts 8

    Re: Linking SQLite.Interop fails for 1.0.60.0

    Hi 

    I am seeing the same with VS2008 SP1

     

    Regards

    Aidan

  • 11-22-2008 5:21 PM In reply to

    Re: Linking SQLite.Interop fails for 1.0.60.0

    Cory Albrecht:

     Hello,

     Trying to build the SQLite.Interop project in the VS2K8 project fails at linking with a whole bunch of errors.

    ...major snippage...

     This does not happen with 1.0.59.0.

     

    No solution for this problem of not being able to build 1.0.60.0?

     

  • 12-03-2008 9:08 AM In reply to

    • masc
    • Top 50 Contributor
    • Joined on 10-26-2007
    • Posts 20

    Re: Linking SQLite.Interop fails for 1.0.60.0

    Yes, I can confirm there's compilation/linker issues with 1.0.60.0, it's pretty borked..

    Referring to SQLite.Interop:

    • Itanium (no config works, build will actually nothing at all, opening project properties will also do nothing and throw unspecified error on subsequent attempts)
    • x64 (debug config will throw linker errors)
    • PocketPC2003 (debug config will throw linker errors)

    Only win32 platform will build correctly in both configs.

    Here's how to resolve the issues..

    x64 debug:

    • Open src folder in VS2008 and select all files therein
    • Open properties for the selected files and set "Exclude files from build" to yes (this is the setting for all other working configs as well, files are there for browsing only, they are included during compile time via interop.c). All files in src should have a red marker now.
    • Go to properties of the project and remove SQLITE_DEBUG from the preprocessr defines in C/C++ settings (SQLITE_DEBUG is not part of any other working build config, so it's probably incompatible atm)

    PocketPC2003 debug:

    • For some reasons the compiler includes calls to some non-unicode functions, which are not valid on WindowsCE. However the calls are dead code  and will be optimized away when setting /O1 for debug config in project configuration->C/C++ settings->optimization, so the linker errors will go away as well

     

    Additionally there's a cs source file missing, it's been posted together with the info that projects don't compile properly before here: http://sqlite.phxsoftware.com/forums/t/1370.aspx

    @Robert. Hope you have time to post a good source package soon..

     

  • 12-03-2008 9:18 AM In reply to

    Re: Linking SQLite.Interop fails for 1.0.60.0

    Sorry about the build problems.  I'm currently swamped at work and haven't had time to put together an update version.

    We've got a big tech event in February so I've been trying to get our software ready for it.

Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems