Re: [sqlite] Oracle connection

[Gary_Gabriel]

Simon Hax wrote:
> I don't know what JET is.
> I testet ADO. That works.
> But it'is slow and you have to write some (to much) code.
>
> Much more better would be a solution like a direct LINK (like an Oracle 
> Database Link).
>
> as shown in my first email:
>
> insert into sqlitetable_columA select ColX from ta...@oracledb
>
> If you have 2 OracleDBs you can define a LINK from one OracleDB to the other,
> which allows you then to do .
Hi Simon, As you demonstrated in your email, it is relatively easy to 
remain in a homogeneous environment. Within this environment you should 
post any questions to the provider being Oracle. The provider interfaces 
the necessary connections. When these connections no longer suffice; 
external links may solve your problem.  But normally you have to acquire 
the know-how.

As you have not explained the reasons why Oracle cannot fulfill your 
requirements and why you are trying to link to SQLite; any answers 
remain superficial. SQLite attaches dbs very easily and in the manner 
you indicated. Use Attach. If Oracle and SQLite were compatible you 
could simply attach dbs.

As your example shows; Oracle and SQLite are two entirely different 
technologies offering diametrically opposed technologies. However it 
makes sense to connect these environments. Oracle has advertised on this 
list that Berkeley Db attaches to backend SQLite databases. Based on the 
Oracle concepts summarily presented; use Berkeley Db to connect Oracle 
to SQLite to achieve your targets if you cannot Attach. Unless you 
provide more information; this should keep you within homogeneous 
interfaces and fulfill your requirements. See the links at the bottom of 
this email for what Oracle advertises as solutions.

- Gary Gabriel

Oracle links from Oracle sources:

"As you may have already heard, the latest release of Oracle Berkeley DB 
now supports SQL, via integration with the SQLite API."

You can read the press release 
, review the 
documentation 
 
or download 
 
the release from the Oracle web site. You can get technical assistance 
on the Berkeley DB Forum 
 or directly 
from Oracle Support 

 




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

Re: [sqlite] WAL in SQLite

[Darren Duncan]

Richard Hipp wrote:
> On Sat, May 29, 2010 at 5:42 PM, Darren Duncan wrote:
>> "3. Transactions that involve changes against multiple ATTACHed
>> databases are atomic for each individual database, but are not atomic across 
>> all
>> databases as a set."
>>
>> I greatly hope that this limitation could go away.  I consider that
>> SQLite's
>> ability to make multiple databases subject to a common transaction is very
>> powerful, and I would even argue, essential.
> 
> See http://www.julianbrowne.com/article/viewer/brewers-cap-theorem

Thanks for the url; that was an interesting read.

> The semantics of ATTACH imply Partition.  In the new WAL design, readers
> never block, which is the same as Accessible.  Hence, we must forgo
> cross-database atomic commits (what the CAP theorem calls "Consistent").

I believe that in SQLite's case, unless perhaps when some of the attached 
databases are on different physical machines from each other or the main one, 
that CAP (you can have at most 2 of 3) isn't applicable, or that there are some 
common situations where it isn't applicable.  (From my reading, CAP mainly 
speaks to the situations where the database is split across multiple physical 
servers.)

Primarily, I speak to the simplified situation where all SQLite databases that 
are open or attached by a SQLite process are all on the same machine, and that 
all simultaneous SQLite processes using any of the same databases at once are 
on 
the same machine.

In this situation, the semantics of ATTACH either do *not* imply Partition, 
because everything is on the same machine, or it might be reason to tweak the 
semantics of ATTACH such that they would not imply Partition.

I note from the SQLite documentation that one can not detach a database in the 
middle of an active transaction; this is a good thing and would contribute 
towards ATTACH not implying Partition.  I don't know if ATTACH is similarly 
restricted or not, as the documentation doesn't say, though arguably this is 
less important; for consistency I might restrict ATTACH to not be possible in a 
transaction either, unless there is a reason to do otherwise.

In the common scenario that I mention, with everything on one machine, would it 
not be unreasonable to support transactions atomic across all attached 
databases 
when WAL is in use?  If it is reasonable, then perhaps SQLite could have a 
partial guarantee, such that transactions when WAL is in use are only 
guaranteed 
atomic across the subset of attached databases that are on the same machine as 
each other or as the SQLite process performing said transaction?

I think that this matter may correspond somewhat to the limits of the 
wal-cache, 
a same-machine limit, though I wouldn't go so far as assume they are connected.

On a tangential matter, where WAL isn't necessarily in use, the documentation 
for ATTACH seems to say that a cross-database transaction wasn't even possible 
before if the main database was ":memory:".  If so, and while I can understand 
why this might have been the case, such that the extra super-journal file that 
marks the collection of journals/databases that are linked, I wonder if this 
can 
be changed somehow.  For example, could SQLite be updated to be able to create 
this extra file even if there is no on-disk main database directly associated 
with it, when there are on-disk databases attached?  It would be nice for the 
availability of cross-database transactions to be orthogonal to which database 
is ":memory:", and only a multiplicity of on-disk databases need synchronizing.

Since journal or WAL files are based on the file names of the on-disk 
databases, 
could it not be possible that when the main database is ":memory:", that the 
user can specify a file name to use some other way?

For example, the syntax for creating/opening a database could be generalized 
such that one would always give a file name, but that one would then provide an 
extra parameter to say whether the database is temporary or not?  A TRUE value 
for this parameter would cause the database to just be in memory in general, 
and 
FALSE means on disk.  Then a possible filename is always provided.  That 
structure might also have other benefits.

Thank you.

-- Darren Duncan

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

Re: [sqlite] rescueing data after accidental DROP

[Wincent]

After the DROP, a CREATE TABLE command is executed to create a table
with the same name as structure.
As for the second question, I am not sure as I ask this question for a
colleague instead of myself. If the payment is not too large, I think
he might be willing to (still, not for sure).

Regards

On Fri, Jun 4, 2010 at 9:54 AM, Simon Slavin  wrote:
>
> On 4 Jun 2010, at 2:44am, Wincent wrote:
>
>> Dear all, I am interested in the same issue as well.
>> Is it possible to recover data after the drop command is executed?
>>
>> I saw from the homepage it is not
>> (http://www.sqlite.org/lang_droptable.html), but I really hope it is
>> possible. Any hints?
>
> Have you make any changes to the database after issuing the DROP TABLE 
> commands ?
>
> Are you willing to pay the SQLite experts to write low-level software to try 
> to recover it for you ?
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Wincent Ronggui HUANG
Doctoral Candidate
Dept of Public and Social Administration
City University of Hong Kong
http://asrr.r-forge.r-project.org/rghuang.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] rescueing data after accidental DROP

[Simon Slavin]

On 4 Jun 2010, at 2:44am, Wincent wrote:

> Dear all, I am interested in the same issue as well.
> Is it possible to recover data after the drop command is executed?
> 
> I saw from the homepage it is not
> (http://www.sqlite.org/lang_droptable.html), but I really hope it is
> possible. Any hints?

Have you make any changes to the database after issuing the DROP TABLE commands 
?

Are you willing to pay the SQLite experts to write low-level software to try to 
recover it for you ?

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

Re: [sqlite] rescueing data after accidental DROP

[Wincent]

Dear all, I am interested in the same issue as well.
Is it possible to recover data after the drop command is executed?

I saw from the homepage it is not
(http://www.sqlite.org/lang_droptable.html), but I really hope it is
possible. Any hints?
Thank you

Best

On Mon, Aug 18, 2008 at 11:31 PM, Mario Bludau  wrote:
> Is there any way to recover data from a sqlite3 database file after dropping
> all (2) tables in it? I can see all the data including the ones that were
> added directly before it happened are in the db file. Is there a tool or
> something that can parse the file for deleted entries? Thanks for your
> answer in advance.
>
> (and yes I know it was my own stupidity that caused it ;) )
>
>
> Mario
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Wincent Ronggui HUANG
Doctoral Candidate
Dept of Public and Social Administration
City University of Hong Kong
http://asrr.r-forge.r-project.org/rghuang.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] on delete no action

[Scott Frankel]

On Jun 1, 2010, at 11:09 PM, Dan Kennedy wrote:

>
> On Jun 2, 2010, at 11:41 AM, Scott Frankel wrote:
>
>>
>> Hi all,
>>
>> I've been lurking for a few days while I explore SQLite and find
>> myself now with a question.
>>
>> What's the correct usage for the "ON DELETE NO ACTION" statement?
>>
>> I'm converting a schema file to SQLite.  Executing a create table
>> statement on the sqlite3 cmd-line, ON DELETE NO ACTION yields an
>> error:  SQL error: near "ON": syntax error.  Yet according to the
>> docs:  "NO ACTION" is a valid action.
>>
>> Is the absence of the ON DELETE rule itself (example 2 below)
>> equivalent to specifying "ON DELETE NO ACTION?"  What concept am I
>> missing from the docs?  ;)
>
> Could be that you need SQLite version 3.6.19 or later.

I wound up changing the line to ON DELETE CASCADE.  My base install of  
SQLite is happy and the behavior seems right.

Thanks for the tip
Scott



>
> Dan.
>
> ___
> 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] Oracle connection

[Tim Romano]

http://tinyurl.com/29sk9pr

On Thu, Jun 3, 2010 at 12:09 PM, Simon Hax  wrote:

> I don't know what JET is.
> I testet ADO. That works.
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Oracle connection

[Simon Hax]

I don't know what JET is.
I testet ADO. That works.
But it'is slow and you have to write some (to much) code.

Much more better would be a solution like a direct LINK (like an Oracle 
Database Link).

as shown in my first email:

insert into sqlitetable_columA select ColX from ta...@oracledb

If you have 2 OracleDBs you can define a LINK from one OracleDB to the other,
which allows you then to do

insert into my_oracle_table_columnA select X from ta...@remoteoracledb

where remoteOracleDB has to be defined earlier as an Oracle Database Link
Really easy to do with Oracle.

S.
 

MSFT JET supports heterogeneous data sources.  Assuming you have a JET MDB
with a data-connection to Oracle and another data-connection to SQLite, and
have attached the relevant tables from each, you could move data from one
back-end data source to the other.  This approach brings the data from the
first back-end out to the client, which then pushes the data out to the
other back-end.
___
NEU: WEB.DE DSL für 19,99 EUR/mtl. und ohne Mindest-Laufzeit!
http://produkte.web.de/go/02/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Oracle connection

[Simon Hax]

On 3 Jun 2010, at 4:25pm, Simon Hax wrote:

> Is something possible like
> 
> insert into sqlite_table.ColumnA select x from ta...@oracledb
> 
> ?
> (Without copying into local memory (firstly do a select  from Oracle )
> and then insert into a Sqlite database (via e.g. ADO ). )
>
> S.

Which set of functions do you expect to be calling to do this ?  The ones 
provided for talking to Oracle or the ones provided for talking to SQLite ?

Simon.
___ 

I think if it will possible, it will only be possible to call it from a sqlite 
perspective,
because with sqlite there is no activ component as with orcale.

Anyway, I implement a sqlite-app and need to read some Oracle data to process 
them in my app.

S.
___
NEU: WEB.DE DSL für 19,99 EUR/mtl. und ohne Mindest-Laufzeit!
http://produkte.web.de/go/02/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Oracle connection

[Tim Romano]

MSFT JET supports heterogeneous data sources.  Assuming you have a JET MDB
with a data-connection to Oracle and another data-connection to SQLite, and
have attached the relevant tables from each, you could move data from one
back-end data source to the other.  This approach brings the data from the
first back-end out to the client, which then pushes the data out to the
other back-end.

http://my.safaribooksonline.com/0596004397/adonetckbk-CHP-3-SECT-6#X2ludGVybmFsX0ZsYXNoUmVhZGVyP3htbGlkPTAtNTk2LTAwNDM5LTcvMTM2

Regards
Tim Romano

On Thu, Jun 3, 2010 at 11:25 AM, Simon Hax  wrote:

> Is something possible like
>
> insert into sqlite_table.ColumnA select x from ta...@oracledb
>
> ?
> (Without copying into local memory (firstly do a select  from Oracle )
> and then insert into a Sqlite database (via e.g. ADO ). )
>
> S.
> ___
> GRATIS für alle WEB.DE Nutzer: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://movieflat.web.de
>
> ___
> 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] Oracle connection

[Simon Slavin]

On 3 Jun 2010, at 4:25pm, Simon Hax wrote:

> Is something possible like
> 
> insert into sqlite_table.ColumnA select x from ta...@oracledb
> 
> ?
> (Without copying into local memory (firstly do a select  from Oracle )
> and then insert into a Sqlite database (via e.g. ADO ). )

Which set of functions do you expect to be calling to do this ?  The ones 
provided for talking to Oracle or the ones provided for talking to SQLite ?

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

[sqlite] Oracle connection

[Simon Hax]

Is something possible like

insert into sqlite_table.ColumnA select x from ta...@oracledb

?
(Without copying into local memory (firstly do a select  from Oracle )
and then insert into a Sqlite database (via e.g. ADO ). )

S.
___
GRATIS für alle WEB.DE Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://movieflat.web.de
___
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] WAL in SQLite

[Richard Hipp]

On Sat, May 29, 2010 at 5:42 PM, Darren Duncan wrote:

>
> 4.  Quoth the raven:
>
> "3. Transactions that involve changes against multiple ATTACHed
> databases
> are atomic for each individual database, but are not atomic across all
> databases
> as a set."
>
> I greatly hope that this limitation could go away.  I consider that
> SQLite's
> ability to make multiple databases subject to a common transaction is very
> powerful, and I would even argue, essential.
>
> I hope that some variation of the method used now with rollback journals
> can be
> applied to databases with WALs, so that the latter can take part in
> cross-database transactions.
>
> I don't see anything in the WAL design that this couldn't be done without
> much
> complexity.
>

See http://www.julianbrowne.com/article/viewer/brewers-cap-theorem

The semantics of ATTACH imply Partition.  In the new WAL design, readers
never block, which is the same as Accessible.  Hence, we must forgo
cross-database atomic commits (what the CAP theorem calls "Consistent").


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

[sqlite] ANN: SQLite Maestro 10.5 released

[SQL Maestro Group]

Hi!

SQL Maestro Group announces the release of SQLite Maestro 10.5, a complete 
Windows GUI solution for SQLite database management. The new version is 
immediately available at

http://www.sqlmaestro.com/products/sqlite/maestro/

New features
=

1. This release has been successfully tested with all the latest SQLite 
versions as well as with 64-bit operating systems including Windows 7 x64. 
The latest available library (3.6.23) is now included into the installation 
package.

2. Support for native foreign keys has been added (SQLite 3.6.19 and 
higher). To enable/disable this feature, use the corresponding option within 
the Create Database Profiles or Edit Database Profile window. This option 
also affects the automatic creation of referential integrity triggers: they 
are NOT created if it is turned ON and vice versa.

3. Table Editor: a possibility of importing data from Clipboard has been 
implemented. It is supposed that columns within the data block are separated 
by the tabulation symbol, records are separated by newlines and the first 
line of the data block contains column headers.

4. The Update Existing Records option has been added to the Data Import 
wizard. If this option is turned ON, the records will be either updated or 
inserted.

5. Data Analysis tool features the following things:

5.1. Starting with this version it is possible to use a wide spectrum of 
aggregate functions such as maximum, minimum, average value, etc. for 
subtotals (the only available function for the previous versions was sum of 
values).

5.2. A possibility of sorting data by summary columns has been added. This 
means, for example, the product you'll see first is not the one which starts 
with an A or Z, but rather the one that has the most or least sales.

5.3. You can also specify the number of top rows that are displayed to view, 
for example, only a specific number of best-selling or worst-selling 
products for each year, month, customer, etc. This will help you to 
concentrate on only the most important information and avoid being overload 
with a lot of superfluous data.

6. The Script Runner window can now be invoked directly from the Tools menu. 
Also the productivity of this tool has been significantly improved.

7. Data Grid: the "Clone current record" command has been added to the popup 
menu. Use it to add a new record which is substantially similar to an 
existing one.

8. BLOB editor: starting with this version it is possible to select a BLOB 
column to edit directly within the editor window.

9. The "Case Insensitive" option has been added to data grid filter settings 
(ON by default).

10. Some other minor improvements and corrections.

Full press-release (with explaining screenshots) is available at:
http://www.sqlmaestro.com/news/company/sqlite_maestro_10_5_released/

Background information:

SQL Maestro Group is engaged in developing complete database admin and 
management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, 
Firebird, SQL Anywhere and MaxDB providing the highest performance, 
scalability and reliability to meet the requirements of today's database 
applications.

Sincerely yours,
The SQL Maestro Group Team
http://www.sqlmaestro.com 

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

Re: [sqlite] Problem with sqlite3

[Black, Michael (IS)]

First off I assume you two know the difference between a DLL .LIB and a static 
.LIB -- they are different.
 
I used Microsoft Visual C++ Studio 2010 Express and 2008 Express and downloaded 
the windows sqlite3 DLL from the website
http://www.sqlite.org/sqlitedll-3_6_23_1.zip
 
 
#1 Open a Visual Studio Command Prompt
#2 lib /def:sqlite3.def /out:sqlite3.lib /machine:x86
#3 cl sqltest.c sqlite3.lib
#4 sqltest
 
Here's a simple test program I used
#include 
#include 
#include "sqlite3.h"
int main()
{
 sqlite3 *db;
 char *errmsg=NULL;
 int rc;
 sqlite3_open("test.db",);
 rc=sqlite3_exec(db, "CREATE TABLE test (testme varchar)",NULL,NULL,);
 if (rc != SQLITE_OK) {
  puts(errmsg);
  sqlite3_free(errmsg);
 }
 rc=sqlite3_exec(db, "INSERT INTO test values ('Testing 
varchar')",NULL,NULL,);
 if (rc != SQLITE_OK) {
  puts(errmsg);
  sqlite3_free(errmsg);
 }
 sqlite3_close(db);
 return 0;
}
 
Compiles and links just fine.
 
First run produces no errors.
2nd run produces:
table test already exists
Just like it should.
 
If you can't do this you have more serious problems.
 
I then made a new console project from existing code under Visual C++ 2010 
Express and 2008 Express, added sqltest.c and sqlite3.lib and built and ran it 
with no problems (you need to copy the DLL into the project directory).
 
If need be I can email you guys a Visual Studio C++ 2008 complete zip file with 
everything in it but you should be able to reproduce this on your own.
 
If you want a static link just download the amalgamation and add sqlite3.c to 
your project or build your own library to link.
http://www.sqlite.org/sqlite-amalgamation-3_6_23_1.zip
 
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
 



From: sqlite-users-boun...@sqlite.org on behalf of Chris 'Xenon' Hanson
Sent: Wed 6/2/2010 8:11 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problem with sqlite3



On 6/2/2010 9:56 AM, lukasz aaa wrote:
> Hello. Sorry for my English.
> I have a problem with the SQLite library reloaded correctly (use in
> project). I'm using VC++ 2010 and Dev.
> I add to project sqlite3.h, copy to folder with source sqlite3.dll and
> sqlite3.lib. I add sqlite3.lib to linker - i search information on
> forums, but can't compile program.
> I make file sqlite3.lib, with program lib.exe, after it not work do it
> with VC++ Create Library, don't work too.
> Error is " error C3861: 'sqlite_open': identifier not found".
> If you have time pleas help me.

  I too am trying to use the current sqlite 3. This is in an application that 
previously
was linked to a static sqlite 3. I can switch to the DLL version if needed. I 
built a .lib
from the .dll and .def file, and switched to the new .h and the .lib, but I had 
no success
linking, with the symbol not found errors.

  I would most like to find a static link version of the most current sqlite 
library, but
failing that, linking with the DLL version would be ok.

  I'm using MSVC++2008 Express.

--
Chris 'Xenon' Hanson, omo sanza lettere  Xenon AlphaPixel.com
PixelSense Landsat processing now available! http://www.alphapixel.com/demos/
"There is no Truth. There is only Perception. To Perceive is to Exist." - Xen
___
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] Problem with sqlite3

[Chris 'Xenon' Hanson]

On 6/2/2010 9:56 AM, lukasz aaa wrote:
> Hello. Sorry for my English.
> I have a problem with the SQLite library reloaded correctly (use in
> project). I'm using VC++ 2010 and Dev.
> I add to project sqlite3.h, copy to folder with source sqlite3.dll and
> sqlite3.lib. I add sqlite3.lib to linker - i search information on
> forums, but can't compile program.
> I make file sqlite3.lib, with program lib.exe, after it not work do it
> with VC++ Create Library, don't work too.
> Error is " error C3861: 'sqlite_open': identifier not found".
> If you have time pleas help me.

  I too am trying to use the current sqlite 3. This is in an application that 
previously
was linked to a static sqlite 3. I can switch to the DLL version if needed. I 
built a .lib
from the .dll and .def file, and switched to the new .h and the .lib, but I had 
no success
linking, with the symbol not found errors.

  I would most like to find a static link version of the most current sqlite 
library, but
failing that, linking with the DLL version would be ok.

  I'm using MSVC++2008 Express.

-- 
Chris 'Xenon' Hanson, omo sanza lettere  Xenon AlphaPixel.com
PixelSense Landsat processing now available! http://www.alphapixel.com/demos/
"There is no Truth. There is only Perception. To Perceive is to Exist." - Xen
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users