Qt-interest Archive, May 2008
compiling sqlite2 driver win XP
Message 1 in thread
I am on qt4.4 and win XP. I'm trying to compile the QSQLITE2 driver,
since I have a problem with the QSQLITE one, and managed to solve it
by changing to sqlite2 under linux.
But in windows when I compile:
configure -qt-sql-sqlite -qt-sql-sqlite2 -release
make
I end up with a compile error:
drivers\sqlite2\qsql_sqlite2.cpp:61:20: sqlite.h: No such file or directory.
and resulting errors.
I tried changing the include to <sqlite2.h> or <sqlite3.h> to no avail.
Where can I find this include? Or how do I compile QSQLITE2?
--
[ signature omitted ]
Message 2 in thread
SQLite3 is included in Qt packages, but SQLite2 is not. So you must
download and compile by yourself, then [re-]compile Qt with SQLite2 driver.
On Thu, 15 May 2008 12:48:30 +0400, Andrzej Szelc
<andrzej.szelc@xxxxxxxxx> wrote:
> I am on qt4.4 and win XP. I'm trying to compile the QSQLITE2 driver,
> since I have a problem with the QSQLITE one, and managed to solve it
> by changing to sqlite2 under linux.
>
> But in windows when I compile:
> configure -qt-sql-sqlite -qt-sql-sqlite2 -release
> make
>
> I end up with a compile error:
> drivers\sqlite2\qsql_sqlite2.cpp:61:20: sqlite.h: No such file or
> directory.
> and resulting errors.
>
> I tried changing the include to <sqlite2.h> or <sqlite3.h> to no avail.
> Where can I find this include? Or how do I compile QSQLITE2?
--
[ signature omitted ]
Message 3 in thread
thanks for the quick reply,
umm, sorry I'm a bit green. What exactly should I download and where from?
I'm asking, because I downloaded the qt4.4 for win with minGW and
tried to recompile this. And it seems there are files that seem to be
correlated to the QSQLITE2 driver (i.e. qsql_sqlite2.cpp), except for
the sqlite.h (and maybe others). Also configure says "sqlite2 - yes"
cheers,
Andrzej
On Thu, May 15, 2008 at 11:35 AM, Constantin Makshin
<dinosaur-rus@xxxxxxxxxxxxxxxxxxxxx> wrote:
> SQLite3 is included in Qt packages, but SQLite2 is not. So you must download
> and compile by yourself, then [re-]compile Qt with SQLite2 driver.
>
> On Thu, 15 May 2008 12:48:30 +0400, Andrzej Szelc <andrzej.szelc@xxxxxxxxx>
> wrote:
>>
>> I am on qt4.4 and win XP. I'm trying to compile the QSQLITE2 driver,
>> since I have a problem with the QSQLITE one, and managed to solve it
>> by changing to sqlite2 under linux.
>>
>> But in windows when I compile:
>> configure -qt-sql-sqlite -qt-sql-sqlite2 -release
>> make
>>
>> I end up with a compile error:
>> drivers\sqlite2\qsql_sqlite2.cpp:61:20: sqlite.h: No such file or
>> directory.
>> and resulting errors.
>>
>> I tried changing the include to <sqlite2.h> or <sqlite3.h> to no avail.
>> Where can I find this include? Or how do I compile QSQLITE2?
>
> --
> Constantin "Dinosaur" Makshin
>
> --
> To unsubscribe - send a mail to qt-interest-request@xxxxxxxxxxxxx with
> "unsubscribe" in the subject or the body.
> List archive and information: http://lists.trolltech.com/qt-interest/
>
>
--
[ signature omitted ]
Message 4 in thread
The last SQLite2 version was released in 2005, so I'm not sure you'll find
it anywhere...
What problem did you have with SQLite3? I'm almost sure that it can be
solved without downgrading to obsolete versions of SQLite.
On Thu, 15 May 2008 14:02:47 +0400, Andrzej Szelc
<andrzej.szelc@xxxxxxxxx> wrote:
> thanks for the quick reply,
> umm, sorry I'm a bit green. What exactly should I download and where
> from?
> I'm asking, because I downloaded the qt4.4 for win with minGW and
> tried to recompile this. And it seems there are files that seem to be
> correlated to the QSQLITE2 driver (i.e. qsql_sqlite2.cpp), except for
> the sqlite.h (and maybe others). Also configure says "sqlite2 - yes"
>
> cheers,
> Andrzej
>
> On Thu, May 15, 2008 at 11:35 AM, Constantin Makshin
> <dinosaur-rus@xxxxxxxxxxxxxxxxxxxxx> wrote:
>> SQLite3 is included in Qt packages, but SQLite2 is not. So you must
>> download
>> and compile by yourself, then [re-]compile Qt with SQLite2 driver.
>>
>> On Thu, 15 May 2008 12:48:30 +0400, Andrzej Szelc
>> <andrzej.szelc@xxxxxxxxx>
>> wrote:
>>>
>>> I am on qt4.4 and win XP. I'm trying to compile the QSQLITE2 driver,
>>> since I have a problem with the QSQLITE one, and managed to solve it
>>> by changing to sqlite2 under linux.
>>>
>>> But in windows when I compile:
>>> configure -qt-sql-sqlite -qt-sql-sqlite2 -release
>>> make
>>>
>>> I end up with a compile error:
>>> drivers\sqlite2\qsql_sqlite2.cpp:61:20: sqlite.h: No such file or
>>> directory.
>>> and resulting errors.
>>>
>>> I tried changing the include to <sqlite2.h> or <sqlite3.h> to no avail.
>>> Where can I find this include? Or how do I compile QSQLITE2?
>>
>> --
>> Constantin "Dinosaur" Makshin
>>
>> --
>> To unsubscribe - send a mail to qt-interest-request@xxxxxxxxxxxxx with
>> "unsubscribe" in the subject or the body.
>> List archive and information: http://lists.trolltech.com/qt-interest/
--
[ signature omitted ]
Message 5 in thread
my problem is here:
http://lists.trolltech.com/qt-interest/2008-04/thread00907-0.html
(there is a follow up discussion with dmitri, that is not under the
link)
it can be summed up as, I cant get bindValue to work with QSQLITE. I
end up with a "?" instead of the bound value.
Under linux if I change the driver to QSQLITE2 it works, and I can
connect to the DB.
I tried all combinations of driver vs. DB file (sqlite 2 or 3) but the
only thing that worked under linux was QSQLITE2 + sqlite2, so I'm
trying to get that to work under win.
Cause QSQLITE + sqlite2 or sqlite3 db file gives me the same problem
with bindValue.
cheers,
Andrzej
On Thu, May 15, 2008 at 12:15 PM, Constantin Makshin
<dinosaur-rus@xxxxxxxxxxxxxxxxxxxxx> wrote:
> The last SQLite2 version was released in 2005, so I'm not sure you'll find
> it anywhere...
>
> What problem did you have with SQLite3? I'm almost sure that it can be
> solved without downgrading to obsolete versions of SQLite.
>
> On Thu, 15 May 2008 14:02:47 +0400, Andrzej Szelc <andrzej.szelc@xxxxxxxxx>
> wrote:
>>
>> thanks for the quick reply,
>> umm, sorry I'm a bit green. What exactly should I download and where from?
>> I'm asking, because I downloaded the qt4.4 for win with minGW and
>> tried to recompile this. And it seems there are files that seem to be
>> correlated to the QSQLITE2 driver (i.e. qsql_sqlite2.cpp), except for
>> the sqlite.h (and maybe others). Also configure says "sqlite2 - yes"
>>
>> cheers,
>> Andrzej
>>
>> On Thu, May 15, 2008 at 11:35 AM, Constantin Makshin
>> <dinosaur-rus@xxxxxxxxxxxxxxxxxxxxx> wrote:
>>>
>>> SQLite3 is included in Qt packages, but SQLite2 is not. So you must
>>> download
>>> and compile by yourself, then [re-]compile Qt with SQLite2 driver.
>>>
>>> On Thu, 15 May 2008 12:48:30 +0400, Andrzej Szelc
>>> <andrzej.szelc@xxxxxxxxx>
>>> wrote:
>>>>
>>>> I am on qt4.4 and win XP. I'm trying to compile the QSQLITE2 driver,
>>>> since I have a problem with the QSQLITE one, and managed to solve it
>>>> by changing to sqlite2 under linux.
>>>>
>>>> But in windows when I compile:
>>>> configure -qt-sql-sqlite -qt-sql-sqlite2 -release
>>>> make
>>>>
>>>> I end up with a compile error:
>>>> drivers\sqlite2\qsql_sqlite2.cpp:61:20: sqlite.h: No such file or
>>>> directory.
>>>> and resulting errors.
>>>>
>>>> I tried changing the include to <sqlite2.h> or <sqlite3.h> to no avail.
>>>> Where can I find this include? Or how do I compile QSQLITE2?
>>>
>>> --
>>> Constantin "Dinosaur" Makshin
>>>
>>> --
>>> To unsubscribe - send a mail to qt-interest-request@xxxxxxxxxxxxx with
>>> "unsubscribe" in the subject or the body.
>>> List archive and information: http://lists.trolltech.com/qt-interest/
>
> --
> Constantin "Dinosaur" Makshin
>
> --
> To unsubscribe - send a mail to qt-interest-request@xxxxxxxxxxxxx with
> "unsubscribe" in the subject or the body.
> List archive and information: http://lists.trolltech.com/qt-interest/
>
>
--
[ signature omitted ]