Hello again, Although the previous suggestion does fix the linker problem for VS2005 (Release and Debug), and for the VS2003 Debug build, I still cannot link the Release build in VS2003. With the 'rtree.c' source file excluded I now get this similar error message:
---- Linking... fts3_tokenizer.obj : error LNK2005: _sqlite3_api already defined in fts3.obj fts3_tokenizer.obj : warning LNK4006: _sqlite3_api already defined in fts3.obj; second definition ignored ---- I am using FTS3 so I cannot disable this optional module. Any ideas please? Thanks again, Ian Ian Thomas wrote: > Hi Shane, > > Thanks very much for the suggestion. I excluded the 'rtree.c' source > file from my build configuration and it now links fine (release and debug). > > I guess there's still an underlying issue but as I don't need the rtree > module it doesn't affect me! > > Thanks again, > > Ian > > > Shane Harrelson wrote: > >> rtree support is an extension to SQLite >> and is not needed to use the core functionality. >> Try leaving the rtree source files out of >> your builds to see if this corrects your >> problem. You might also consider using >> the SQLITE_OMIT_LOAD_EXTENSION >> option as well. >> >> http://www.sqlite.org/compile.html >> >> >> On Mon, Feb 16, 2009 at 9:29 AM, Ian Thomas <tho...@ccdc.cam.ac.uk> wrote: >> >> >>> Hello, >>> >>> I'm trying to compile my own debug build of SQLite v3.6.3 in Visual >>> Studio 2005 so that I can step through a problem I'm having with my >>> application. I have followed the instructions found here: >>> >>> http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet >>> >>> Using the standard v3.6.3 source tree (not the amalgamation version) >>> everything compiles fine but fails to link with this error: >>> >>> 1>rtree.obj : error LNK2005: _sqlite3_api already defined in >>> fts3_tokenizer.obj >>> 1> Creating library >>> D:\x_mirror\buildman\tools\sqlite-3.6.3\SQLiteVS2005\Debug\SQLiteVS2005.lib >>> and object >>> D:\x_mirror\buildman\tools\sqlite-3.6.3\SQLiteVS2005\Debug\SQLiteVS2005.exp >>> 1>D:\x_mirror\buildman\tools\sqlite-3.6.3\SQLiteVS2005\Debug\SQLiteVS2005.dll >>> : fatal error LNK1169: one or more multiply defined symbols found >>> >>> I have only two SQLite preprocessor defines set in my project: >>> >>> SQLITE_ENABLE_COLUMN_METADATA >>> SQLITE_ENABLE_FTS3 >>> >>> I get this error both with and without the SQLITE_ENABLE_FTS3 define. >>> >>> I get the same linker error when trying to build SQLite v3.6.10 and when >>> trying to use Visual Studio 2003 instead of 2005. >>> >>> I'm sure there must be an easy fix for this problem - any advice would >>> be really appreciated. I imagine I could use the /FORCE:MULTIPLE linker >>> option to get past this but I'm reluctant to do so without checking first. >>> >>> Thanks in advance, >>> >>> Ian Thomas >>> >>> >>> LEGAL NOTICE >>> Unless expressly stated otherwise, information contained in this >>> message is confidential. If this message is not intended for you, >>> please inform postmas...@ccdc.cam.ac.uk and delete the message. >>> The Cambridge Crystallographic Data Centre is a company Limited >>> by Guarantee and a Registered Charity. >>> Registered in England No. 2155347 Registered Charity No. 800579 >>> Registered office 12 Union Road, Cambridge CB2 1EZ. >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >>> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- Ian Thomas Scientific Software Engineer CCDC 12 Union Road Cambridge CB2 1EZ UK Tel - +44 1223 763884 LEGAL NOTICE Unless expressly stated otherwise, information contained in this message is confidential. If this message is not intended for you, please inform postmas...@ccdc.cam.ac.uk and delete the message. The Cambridge Crystallographic Data Centre is a company Limited by Guarantee and a Registered Charity. Registered in England No. 2155347 Registered Charity No. 800579 Registered office 12 Union Road, Cambridge CB2 1EZ. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
