[sqlite] 3.4.2 compile error

2007-09-26 Thread Zavier Sheran
../sqlite/src/tclsqlite.c: At top level:
../sqlite/src/tclsqlite.c:2430: error: syntax error before "int"
../sqlite/src/tclsqlite.c:2430: error: syntax error before '*' token
../sqlite/src/tclsqlite.c: In function `Tclsqlite_SafeInit':
../sqlite/src/tclsqlite.c:2430: error: `TCL_OK' undeclared (first use in
this function)
make: *** [tclsqlite.lo] Error 1


keep getting this error. using ../sqlite/configure
--prefix=/usr/local/sqlite  or ../sqlite/configure .. no luck.. RHEL 3

Any ideas?


[sqlite] Error opening databas on Windows

2007-09-26 Thread Dusan Gibarac
Need help. sometimes, on WinXP open a database fails with error:
SQLITE_CANTOPEN

In background there is a service using said database for occasionally. How
to investigate details of failing open? What is recommendation if any kind
of database lock occurs - for example other process is writing to the file,
antivirus software is touching the database file, etc? 

 

Dusan Gibarac

 



Re: [sqlite] segfault or I/O error during vaccum

2007-09-26 Thread Joe Wilson
--- Kipp Cannon <[EMAIL PROTECTED]> wrote:
> Ah hah!  That got it.  vacuum is creating temporary files in /tmp, but on 
> the computers in question /tmp is mounted on a really small file system 
> and it's getting filled by whatever vacuum is doing there.  Thanks!

See also:

  PRAGMA temp_store_directory = 'directory-name';

http://sqlite.org/pragma.html
 
> Doesn't explain the occasional segfault, but I can't reproduce those 
> easily.  I'll keep my eye out.  Probably something that only happens in 
> the out-of-disk-space code path, so I might not see it again after I'm 
> not running out of disk space.  OK, great, thanks again.

See if you can catch the crash with valgrind with insufficient temp_store space.
If so, post its output to the list.



   

Be a better Heartthrob. Get better relationship answers from someone who knows. 
Yahoo! Answers - Check it out. 
http://answers.yahoo.com/dir/?link=list&sid=396545433

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] why not get max-constants from limits.h ?

2007-09-26 Thread Evans, Mark (Tandem)
I am building sqlite 3.5.0 using x-dev tools for HP NonStop OSS target
machine and am working through some issues.  One of the issues is a
compiler error that results from a literal, SQLITE_BIG_DBL, used in
src/where.c.  That literal is defined in sqliteInt.h as (1e99) which is
bigger than the maximum double for this machine, defined in
/usr/include/limits.h as #define DBL_MAX  1.15792089237316192e77.  I can
obviously work around this problem by adding a -DSQLITE_BIG_DBL to the
c-flags, but I'm curious why sqlite does not #include  and use
DBL_MAX as the default value for SQLITE_BIG_DBL.

Regards,
Mark


RE: [sqlite] Wrapper ADO like for VB6

2007-09-26 Thread RB Smissaert
No, haven't tried dhRPCServer as I only work with a local database
and single users.

RBS


-Original Message-
From: Giuliano [mailto:[EMAIL PROTECTED] 
Sent: 26 September 2007 13:58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Wrapper ADO like for VB6

Thanks,

I have seen and it seams to be really interesting. I will try it for sure.
Did you also try the dhRPCServer that should act like a server/client?


- Original Message - 
From: "RB Smissaert" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, September 26, 2007 2:47 PM
Subject: RE: [sqlite] Wrapper ADO like for VB6


>I am using dhSQLite, which you can download from here:
> http://www.thecommon.net/2.html
>
> I have tried several wrappers for VB(A) (about 4 or 5) and this
> is the best one. Good support as well.
>
> RBS
>
>
> -Original Message-
> From: Giuliano [mailto:[EMAIL PROTECTED]
> Sent: 26 September 2007 13:35
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Wrapper ADO like for VB6
>
> Hello,
>
> I am porting a big program from SQLServ.. to SQLite and I have
> seen that there are many VB6 wrappers available. I would like to
> get some suggestion from people who already use one, to be sure
> to make the right decision (important: ADO like, stability, upgrades
> etc...)
>
> Many thanks in advance,
> Giuliano
>
>
>
>

-
> To unsubscribe, send email to [EMAIL PROTECTED]
>

-
>
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Wrapper ADO like for VB6

2007-09-26 Thread Giuliano

Thanks,

I have seen and it seams to be really interesting. I will try it for sure.
Did you also try the dhRPCServer that should act like a server/client?


- Original Message - 
From: "RB Smissaert" <[EMAIL PROTECTED]>

To: 
Sent: Wednesday, September 26, 2007 2:47 PM
Subject: RE: [sqlite] Wrapper ADO like for VB6



I am using dhSQLite, which you can download from here:
http://www.thecommon.net/2.html

I have tried several wrappers for VB(A) (about 4 or 5) and this
is the best one. Good support as well.

RBS


-Original Message-
From: Giuliano [mailto:[EMAIL PROTECTED]
Sent: 26 September 2007 13:35
To: sqlite-users@sqlite.org
Subject: [sqlite] Wrapper ADO like for VB6

Hello,

I am porting a big program from SQLServ.. to SQLite and I have
seen that there are many VB6 wrappers available. I would like to
get some suggestion from people who already use one, to be sure
to make the right decision (important: ADO like, stability, upgrades
etc...)

Many thanks in advance,
Giuliano



-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Wrapper ADO like for VB6

2007-09-26 Thread RB Smissaert
I am using dhSQLite, which you can download from here:
http://www.thecommon.net/2.html

I have tried several wrappers for VB(A) (about 4 or 5) and this
is the best one. Good support as well.

RBS


-Original Message-
From: Giuliano [mailto:[EMAIL PROTECTED] 
Sent: 26 September 2007 13:35
To: sqlite-users@sqlite.org
Subject: [sqlite] Wrapper ADO like for VB6

Hello,

I am porting a big program from SQLServ.. to SQLite and I have
seen that there are many VB6 wrappers available. I would like to
get some suggestion from people who already use one, to be sure
to make the right decision (important: ADO like, stability, upgrades
etc...)

Many thanks in advance,
Giuliano



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Wrapper ADO like for VB6

2007-09-26 Thread Giuliano
Hello,

I am porting a big program from SQLServ.. to SQLite and I have
seen that there are many VB6 wrappers available. I would like to
get some suggestion from people who already use one, to be sure
to make the right decision (important: ADO like, stability, upgrades
etc...)

Many thanks in advance,
Giuliano

[sqlite] Wrapper ADO like for VB6

2007-09-26 Thread Giuliano
Hello,

I am porting a big program from SQLServ.. to SQLite and I have
seen that there are many VB6 wrappers available. I would like to
get some suggestion from people who already use one, to be sure
to make the right decision (important: ADO like, stability, upgrades
etc...)

Many thanks in advance,
Giuliano