Re: [sqlite] First Program using sqlite3.dll - Linker Errors

[Neil Jeffery]

Thanks very much, it worked!

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paul Perry
Sent: 28 March 2009 18:25
To: General Discussion of SQLite Database
Subject: Re: [sqlite] First Program using sqlite3.dll - Linker Errors

Add the lib file you generated with lib.exe into your project.  Just
pointing to the directory is not enough.  That should fix up your link
errors.




On Sat, Mar 28, 2009 at 10:53 AM, Neil Jeffery
<john_headb...@hotmail.com>wrote:

>
> Hi All,
>
>
>
> I am attempting to write a program which will use the sqlite3.dll file.  I
> am developing in Visual Studio 2008 Express on Windows Vista.
>
>
>
> I downloaded this file: http://www.sqlite.org/sqlitedll-3_6_11.zip which
> contains the dll and a definitions file.  I have then used lib.exe to
> generate a.lib file.  The lib file is currently in C:\SQLITE\.
>
>
>
> I have done the following to alter the Linker configuration in the
project:
>
>
>
> 1)Right Click Project -> Properties
>
> 2)Configuration Properties -> Linker
>
> 3)I entered "C:\SQLITE\" in the "Additional Library Directories" property
> field
>
>
>
> I believe that I need a sqlite3 header file in order to use the functions
> in my code.  This is not included in the file I downloaded above.  I have
> thus downloaded http://www.sqlite.org/sqlite-amalgamation-3_6_11.zip and
> taken sqlite3.h from this and added it to my project.
>
>
>
> I have only one source file in the project at present which is as
> http://www.sqlite.org/quickstart.html.  Trying to build throws up compile
> errors about the exit keyword, so I have added #include  as
well.
>
>
>
> Now the project compiles without warnings or errors, but I see the
> following Linker Errors:
>
>
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_free
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_exec
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_close
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_errmsg
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_open
> referenced in function _main
>
>
1>*PATH*\Projects\Testing\SQLITE1\Debug\SQLITE1.exe
> : fatal error LNK1120: 5 unresolved externals
>
>
>
> I have never worked with DLLs before so I could be something quite
> fundamental wrong.
>
>
>
> Any help or thoughts would be welcome.
>
>
>
> Many thanks,
>
>
>
> Neil
>
> _
> View your Twitter and Flickr updates from one place - Learn more!
> http://clk.atdmt.com/UKM/go/137984870/direct/01/
> ___
> 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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] First Program using sqlite3.dll - Linker Errors

[Paul Perry]

Add the lib file you generated with lib.exe into your project.  Just
pointing to the directory is not enough.  That should fix up your link
errors.




On Sat, Mar 28, 2009 at 10:53 AM, Neil Jeffery wrote:

>
> Hi All,
>
>
>
> I am attempting to write a program which will use the sqlite3.dll file.  I
> am developing in Visual Studio 2008 Express on Windows Vista.
>
>
>
> I downloaded this file: http://www.sqlite.org/sqlitedll-3_6_11.zip which
> contains the dll and a definitions file.  I have then used lib.exe to
> generate a.lib file.  The lib file is currently in C:\SQLITE\.
>
>
>
> I have done the following to alter the Linker configuration in the project:
>
>
>
> 1)Right Click Project -> Properties
>
> 2)Configuration Properties -> Linker
>
> 3)I entered "C:\SQLITE\" in the "Additional Library Directories" property
> field
>
>
>
> I believe that I need a sqlite3 header file in order to use the functions
> in my code.  This is not included in the file I downloaded above.  I have
> thus downloaded http://www.sqlite.org/sqlite-amalgamation-3_6_11.zip and
> taken sqlite3.h from this and added it to my project.
>
>
>
> I have only one source file in the project at present which is as
> http://www.sqlite.org/quickstart.html.  Trying to build throws up compile
> errors about the exit keyword, so I have added #include  as well.
>
>
>
> Now the project compiles without warnings or errors, but I see the
> following Linker Errors:
>
>
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_free
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_exec
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_close
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_errmsg
> referenced in function _main
>
> 1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_open
> referenced in function _main
>
> 1>*PATH*\Projects\Testing\SQLITE1\Debug\SQLITE1.exe
> : fatal error LNK1120: 5 unresolved externals
>
>
>
> I have never worked with DLLs before so I could be something quite
> fundamental wrong.
>
>
>
> Any help or thoughts would be welcome.
>
>
>
> Many thanks,
>
>
>
> Neil
>
> _
> View your Twitter and Flickr updates from one place – Learn more!
> http://clk.atdmt.com/UKM/go/137984870/direct/01/
> ___
> 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

[sqlite] First Program using sqlite3.dll - Linker Errors

[Neil Jeffery]

Hi All, 

 

I am attempting to write a program which will use the sqlite3.dll file.  I am 
developing in Visual Studio 2008 Express on Windows Vista.

 

I downloaded this file: http://www.sqlite.org/sqlitedll-3_6_11.zip which 
contains the dll and a definitions file.  I have then used lib.exe to generate 
a.lib file.  The lib file is currently in C:\SQLITE\.

 

I have done the following to alter the Linker configuration in the project:

 

1)Right Click Project -> Properties

2)Configuration Properties -> Linker

3)I entered "C:\SQLITE\" in the "Additional Library Directories" property field

 

I believe that I need a sqlite3 header file in order to use the functions in my 
code.  This is not included in the file I downloaded above.  I have thus 
downloaded http://www.sqlite.org/sqlite-amalgamation-3_6_11.zip and taken 
sqlite3.h from this and added it to my project.

 

I have only one source file in the project at present which is as 
http://www.sqlite.org/quickstart.html.  Trying to build throws up compile 
errors about the exit keyword, so I have added #include  as well.

 

Now the project compiles without warnings or errors, but I see the following 
Linker Errors:

 

1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_free referenced 
in function _main

1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_exec referenced 
in function _main

1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_close 
referenced in function _main

1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_errmsg 
referenced in function _main

1>MAIN.obj : error LNK2019: unresolved external symbol _sqlite3_open referenced 
in function _main

1>*PATH*\Projects\Testing\SQLITE1\Debug\SQLITE1.exe : 
fatal error LNK1120: 5 unresolved externals

 

I have never worked with DLLs before so I could be something quite fundamental 
wrong.

 

Any help or thoughts would be welcome.

 

Many thanks,

 

Neil

_
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users