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

Reply via email to