Re: [sqlite] Complile and connecting to SQLite
Hi Dennis, Doug, thanks a lot for this info, helps a lot Aaron. On 02/05/06, Doug Nebeker <[EMAIL PROTECTED]> wrote: Pre-compiled Windows DLL: http://www.sqlite.org/sqlitedll-3_3_5.zip Source for Windows: http://www.sqlite.org/sqlite-source-3_3_5.zip You can compile the source (I happen to do it with Microsoft Visual Studio) and get the DLL as well. The links above are available on the following page: http://www.sqlite.org/download.html There are other downloads there that might be helpful too so look around. - Doug -Original Message- From: Aaron Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 9:49 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Complile and connecting to SQLite there is no dll file in the sqlite source On 02/05/06, Eric Bohlman <[EMAIL PROTECTED]> wrote: > > Aaron Jones wrote: > > Windows XP, don't know what compiler to use. > > MinGW and all the common versions of Visual Studio work. > > > > > I am creating a GUI to SQLite, so need my interface to connect to > SQLite, > > and wanted to know what it connected to, the source code or the exe > file. > > SQLite is an embeddable engine (library), not a server, so you don't > "connect to" it, you link it into your program. The "exe file" is > simply a command-line shell program that's been linked with the SQLite > library. You can link SQLite either statically or dynamically (.dll) > the same way you can link any other library. > To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
RE: [sqlite] Complile and connecting to SQLite
Pre-compiled Windows DLL: http://www.sqlite.org/sqlitedll-3_3_5.zip Source for Windows: http://www.sqlite.org/sqlite-source-3_3_5.zip You can compile the source (I happen to do it with Microsoft Visual Studio) and get the DLL as well. The links above are available on the following page: http://www.sqlite.org/download.html There are other downloads there that might be helpful too so look around. - Doug -Original Message- From: Aaron Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 9:49 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Complile and connecting to SQLite there is no dll file in the sqlite source On 02/05/06, Eric Bohlman <[EMAIL PROTECTED]> wrote: > > Aaron Jones wrote: > > Windows XP, don't know what compiler to use. > > MinGW and all the common versions of Visual Studio work. > > > > > I am creating a GUI to SQLite, so need my interface to connect to > SQLite, > > and wanted to know what it connected to, the source code or the exe > file. > > SQLite is an embeddable engine (library), not a server, so you don't > "connect to" it, you link it into your program. The "exe file" is > simply a command-line shell program that's been linked with the SQLite > library. You can link SQLite either statically or dynamically (.dll) > the same way you can link any other library. > To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
Re: [sqlite] Complile and connecting to SQLite
Aaron Jones wrote: there is no dll file in the sqlite source Aaron, To use SQLite on Windows you need to download 3 separate files. http://www.sqlite.org/sqlite-3_3_5.zip contains a command line shell statically linked to the sqlite library. You can use it to create, open, test sqlite databases, or to try out SQL statements etc. http://www.sqlite.org/sqlitedll-3_3_5.zip contains a precompiled DLL that you can use to dynamically link the sqlite library to your application. This DLL is also used by some third party sqlite GUI tools etc. http://www.sqlite.org/sqlite-source-3_3_5.zip contains preprocessed source files. In particular it contains sqlite.h which is needed to compile applications that will link to sqlite (either statically or dynamically). You will also need these source files to include sqlite directly into your application, or to build a static library to link with your application. HTH Dennis Cote
Re: [sqlite] Complile and connecting to SQLite
there is no dll file in the sqlite source On 02/05/06, Eric Bohlman <[EMAIL PROTECTED]> wrote: Aaron Jones wrote: > Windows XP, don't know what compiler to use. MinGW and all the common versions of Visual Studio work. > > I am creating a GUI to SQLite, so need my interface to connect to SQLite, > and wanted to know what it connected to, the source code or the exe file. SQLite is an embeddable engine (library), not a server, so you don't "connect to" it, you link it into your program. The "exe file" is simply a command-line shell program that's been linked with the SQLite library. You can link SQLite either statically or dynamically (.dll) the same way you can link any other library.
Re: [sqlite] Complile and connecting to SQLite
Aaron Jones wrote: Windows XP, don't know what compiler to use. MinGW and all the common versions of Visual Studio work. I am creating a GUI to SQLite, so need my interface to connect to SQLite, and wanted to know what it connected to, the source code or the exe file. SQLite is an embeddable engine (library), not a server, so you don't "connect to" it, you link it into your program. The "exe file" is simply a command-line shell program that's been linked with the SQLite library. You can link SQLite either statically or dynamically (.dll) the same way you can link any other library.
Re: [sqlite] Complile and connecting to SQLite
You cannot go wrong by using Mingw. The package with the Dev-Cpp IDE works well and compiles Sqlite without problems. JS Aaron Jones wrote: Windows XP, don't know what compiler to use. I am creating a GUI to SQLite, so need my interface to connect to SQLite, and wanted to know what it connected to, the source code or the exe file. On 01/05/06, Gerry Snyder <[EMAIL PROTECTED]> wrote: Aaron Jones wrote: > Hi, I have to questions I would like some help on please > > 1. How do you compile SQLite from the source code What OS, what compiler, ...? And why do you need to compile? Why not use a precompiled executable? > > and > > 2. How do I connect to SQLite? Do I connect to the source code or > the exe > file? You don't. You just run the executable. If you want detailed answers, you have to ask detailed questions (and that requires reading the info on the web page and wiki first, and maybe even trying something and getting far enough to run into trouble). Gerry
Re: [sqlite] Complile and connecting to SQLite
To compile just read the instructions with thye source distribution. Sqlite doesn't connect, it is a library which you link into your application. JS Aaron Jones wrote: Hi, I have to questions I would like some help on please 1. How do you compile SQLite from the source code and 2. How do I connect to SQLite? Do I connect to the source code or the exe file? Many thanks. Aaron
Re: [sqlite] Complile and connecting to SQLite
There are wrappers here to connect to SQLite from loads of different languages and toolkits :- http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers On 02/05/06, Aaron Jones <[EMAIL PROTECTED]> wrote: Windows XP, don't know what compiler to use. I am creating a GUI to SQLite, so need my interface to connect to SQLite, and wanted to know what it connected to, the source code or the exe file. On 01/05/06, Gerry Snyder <[EMAIL PROTECTED]> wrote: > > Aaron Jones wrote: > > Hi, I have to questions I would like some help on please > > > > 1. How do you compile SQLite from the source code > What OS, what compiler, ...? > > And why do you need to compile? Why not use a precompiled executable? > > > > and > > > > 2. How do I connect to SQLite? Do I connect to the source code or > > the exe > > file? > You don't. You just run the executable. > > If you want detailed answers, you have to ask detailed questions > (and that requires reading the info on the web page and wiki first, > and maybe even trying something and getting far enough to run into > trouble). > > Gerry >
Re: [sqlite] Complile and connecting to SQLite
Windows XP, don't know what compiler to use. I am creating a GUI to SQLite, so need my interface to connect to SQLite, and wanted to know what it connected to, the source code or the exe file. On 01/05/06, Gerry Snyder <[EMAIL PROTECTED]> wrote: Aaron Jones wrote: > Hi, I have to questions I would like some help on please > > 1. How do you compile SQLite from the source code What OS, what compiler, ...? And why do you need to compile? Why not use a precompiled executable? > > and > > 2. How do I connect to SQLite? Do I connect to the source code or > the exe > file? You don't. You just run the executable. If you want detailed answers, you have to ask detailed questions (and that requires reading the info on the web page and wiki first, and maybe even trying something and getting far enough to run into trouble). Gerry
Re: [sqlite] Complile and connecting to SQLite
Aaron Jones wrote: Hi, I have to questions I would like some help on please 1. How do you compile SQLite from the source code What OS, what compiler, ...? And why do you need to compile? Why not use a precompiled executable? and 2. How do I connect to SQLite? Do I connect to the source code or the exe file? You don't. You just run the executable. If you want detailed answers, you have to ask detailed questions (and that requires reading the info on the web page and wiki first, and maybe even trying something and getting far enough to run into trouble). Gerry