[sqlite] Sqlite ODBC Query

2016-04-13 Thread Manasi Deshpande
Hello All, 1. RetCode = SQLExecDirect(hStmt, (SQLTCHAR*)query.c_str(), SQL_NTS); 2. When success RetCode = SQLFetch(hStmt); 3. if (SQL_SUCCEEDED(RetCode)) { While(SQLDescribeCol) { Switch(colDataType) { Case SQL_INTEGER: SQLGetData is called to fetch the data from stmt

[sqlite] New SQLite ODBC driver

2015-07-15 Thread Denis Yanov
Devart team is proud to introduce new SQLite ODBC Drivers. The most significant features in this version are: - Direct Mode - allows to connect to your databases directly via TCP/IP avoiding DB client software, thus simplifying application deployment process and increasing performance

[sqlite] ODBC

2015-03-25 Thread Bart Smissaert
Best is to use the VB (6 and VBA) wrapper from Olaf Schmidt you can download here: http://www.vbrichclient.com/#/en/About/ Examples how to use are there as well. RBS On Wed, Mar 25, 2015 at 12:06 PM, Preston King wrote: > Hello, > > I recently installed the sqliteodbc, sqlite3 ODBC

[sqlite] ODBC

2015-03-25 Thread Preston King
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert Sent: Wednesday, March 25, 2015 8:12 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] ODBC Best is to use the VB (6 and VBA) wrapper from Olaf Schmidt you can download here: http://www.vbrichclient.com/#/en

[sqlite] ODBC

2015-03-25 Thread Preston King
Hello, I recently installed the sqliteodbc, sqlite3 ODBC v0.9991.00.00, to use with Excel 2010. I created some VBA code to import sqlite data into my worksheet. The issue that I am having is that data is truncated to 255 characters. I am assuming that I have the latest ODBC driver as I have

[sqlite] re SQLite ODBC Driver,

2010-11-06 Thread Len(c-sharplizards)
Thanks Kees, Christian, SQLSetConnectAttrW(q->hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF, 0); this is what I already had and I think you have answered the question with "The SQLite ODBC driver allows only one SQL statement per SQLExecDirect()", this is the conc

Re: [sqlite] ODBC Driver

2010-11-06 Thread christian.wer...@t-online.de
> I do not seem to be able to parse a multiple insert statement through > the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT > TRANSACTION does anyone have any ideas? The SQLite ODBC driver allows only one SQL statement per SQLExecDirect() and SQLPrepare(). W

Re: [sqlite] ODBC Driver

2010-11-06 Thread Kees Nuyt
On Sat, 06 Nov 2010 15:36:46 +1100, "Len(c-sharplizards)" wrote: > I do not seem to be able to parse a multiple insert statement through > the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT > TRANSACTION does anyone have any ideas? You don't give

[sqlite] ODBC Driver

2010-11-05 Thread Len(c-sharplizards)
I do not seem to be able to parse a multiple insert statement through the odbc drive using SQLExecDirect(...) I have tried with BEGIN, COMMIT TRANSACTION does anyone have any ideas? Regrards ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [ODBC] - possible Bug

2010-05-31 Thread Oliver Peters
[...] The solution is: mark "Benannte Parameter durch '?' ersetzen" (translation: "Replace named parameter with '?'" in OpenOffice Base Thanks to Christian Werner ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [ODBC] - possible Bug

2010-05-28 Thread Oliver Peters
Simon Slavin writes: [...] > > Neither mainforms nor subforms are part of SQLite. Your problem is either with ODBC or OpenOffice and > you'll probably get better advice elsewhere. [...] But Mr. Werner is part of the team (http://www.sqlite.org/crew.html) and so a working

Re: [sqlite] [ODBC] - possible Bug

2010-05-28 Thread Simon Slavin
On 28 May 2010, at 6:04pm, Oliver Peters wrote: > Despite using the very simple way to create the form (via assistant) I can't > connect mainform and subform. Neither mainforms nor subforms are part of SQLite. Your problem is either with ODBC or OpenOffice and you'll probably get better

[sqlite] [ODBC] - possible Bug

2010-05-28 Thread Oliver Peters
Hello, configuration - OS- WinXP 32 sqlite- 3.6.23.1 odbc - 0.86 (http://www.ch-werner.de/sqliteodbc/) frontend - OpenOffice.org (3.2. and 3.2.1 RC2 tested) target -- In "OpenOffice Base" I need a form where a mainform controls the appearance of records in a

Re: [sqlite] SQLite ODBC Driver - relative path

2010-03-17 Thread Guy Hachlili
Hello. On 17/03/2010 04:16, Shen Nan wrote: > I used SQLite ODBC Driver to display data in Excel, and everything works > fine. > Except in the connection String, I have to enter an absolute path, which is > very troublesome every time I move the file. > I wonder is there any

[sqlite] SQLite ODBC Driver - relative path

2010-03-17 Thread Shen Nan
Hi sqlite users, I used SQLite ODBC Driver to display data in Excel, and everything works fine. Except in the connection String, I have to enter an absolute path, which is very troublesome every time I move the file. I wonder is there any way to specify relative path instead

Re: [sqlite] ODBC Problem with SQLite

2009-12-03 Thread Oliver Peters
ODBC-ERROR: NO -- CREATE TABLE test_02( a INTEGER PRIMARY KEY, b TEXT ); I already sent a mail to the developer greetings oliver > -Ursprüngliche Nachricht- > Von: "rriera" <regori...@gmail.com> > Gesendet: 03.12.09 13:00:00 > An: sqlite-user

[sqlite] ODBC Problem with SQLite

2009-12-03 Thread rriera
Hi, I installed the ODBC 2.8.17/3.6.20 SQLite driver package and I did the set up, but when I want to open a SQLite database with MS Access, Access opens the DB but without all the data. Do you had this problem some time? Or know any solution? Thanks, Roger -- View this message in

Re: [sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?

2009-10-15 Thread Mohit Sindhwani
Shane Harrelson wrote: > I know of no conflicts. I regularly test against SQL Server 2005, > MySQL, OracleXE, and SQLite all via ODBC interfaces (specifically > Christian Werner's ODBC interface for SQLite). The various ODBC > interfaces all play happily. > ...and numerous applications

Re: [sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?

2009-10-15 Thread Shane Harrelson
e REBOL to develop a GUI frontend.  For > reporting, I thought I might use MS Access called by REBOL code to provide > canned reports against the SQLite database.  I believe I need to use the > SQLite ODBC driver (http://www.ch-werner.de/sqliteodbc/) for Access to link > to the SQLi

[sqlite] Conflict with SQLite ODBC Driver and MS Office 2007 ?

2009-10-14 Thread Jack Ort
. For reporting, I thought I might use MS Access called by REBOL code to provide canned reports against the SQLite database. I believe I need to use the SQLite ODBC driver (http://www.ch-werner.de/sqliteodbc/) for Access to link to the SQLite db. Now my question: my IT Manager is witholding approval

Re: [sqlite] ODBC drivers are faster than NAtive C API why?

2009-01-28 Thread Michael Knigge
> I tried to execute some SQL queries using drivers(sqliteodbc) and Native c > API but i found that ODBC drivers are working twice faster than c API. > Why this behavior is coming as c APIs are supposed to be faster than > drivers? May be the old issue: You've been using transactions with your

[sqlite] ODBC drivers are faster than NAtive C API why?

2009-01-28 Thread goldy
Hi all, I tried to execute some SQL queries using drivers(sqliteodbc) and Native c API but i found that ODBC drivers are working twice faster than c API. Why this behavior is coming as c APIs are supposed to be faster than drivers? Any thought on this would be appreciated. Regards

Re: [sqlite] ODBC test

2008-12-04 Thread Griggs, Donald
Regarding: "Does there any test case exist for ODBC testing of sqlite, how one can be sure about sqlite working with ODBC." = Sqlite itself does not interface directly with ODBC. Some nice folks have written ODBC wrappers, though, and it is those folks

[sqlite] ODBC test

2008-12-04 Thread goldy
Hi, Does there any test case exist for ODBC testing of sqlite, how one can be sure about sqlite working with ODBC. Regards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Performance - SQLite ODBC against SQLite C API on SLES10

2008-10-09 Thread Darko Filipovic
Hello, I'm doing some performance tests comparing SQLite ODBC and SQLite C API (both 3.5.2 version) on SLES10 (64bit). I'm inserting 1000 rows into 4 columns table (int, int64, double, int64) out of transaction and I'm getting much lower performance using SQLite API (about 10 seconds slower

[sqlite] Free the text (SQLite ODBC driver 0.79 & ADO 2.8 problem)

2008-10-07 Thread markbrad
). Reading data via linked tables or pass-through queries in MS Access is no problem. I’ve tried various versions of ADO (currently on 2.8) and the SQLite ODBC driver (currently on 0.79). I've tried all manor of cursor and lock types. The SpatiaLite library extension has been turned off, still

Re: [sqlite] ODBC driver for C error "only one SQL statement allowed"

2008-08-11 Thread Mihai Limbasan
Abshagen, Martin RD-AS2 wrote: Hi, sqlite-users, am evaluating Sqlite ODBC driver for C (current sqliteodbc.exe by Ch. Werner, http://www.ch-werner.de/sqliteodbc/). After defining successfully two tables "mytable" and "mysequence", I tried to define a trigger by means of

[sqlite] ODBC driver for C error "only one SQL statement allowed"

2008-08-11 Thread Abshagen, Martin RD-AS2
Hi, sqlite-users, am evaluating Sqlite ODBC driver for C (current sqliteodbc.exe by Ch. Werner, http://www.ch-werner.de/sqliteodbc/). After defining successfully two tables "mytable" and "mysequence", I tried to define a trigger by means of "CREATE TRIGGER trg BEFORE I

[sqlite] SQLite & ODBC or DDE

2008-06-26 Thread The Tango Club
Dear SQLite Users, I am considering purchasing an application written in SQLite. Can anyone advise me if I can use ODBC or DDE with the database? Many Thanks Liz -- w TheTangoClub.com e [EMAIL PROTECTED] _ t +44 20 7701 9647

Re: [sqlite] ODBC driver C source file includes a header which was notshipped

2008-04-25 Thread Christian Werner
"Abshagen, Martin RD-AS2" wrote: > > Hi, > > am trying to use the Sqlite3 ODBC driver for C, provided by Christian Werner > (http://www.ch-werner.de/sqliteodbc/, product sqliteodbc-0.77-1.src.rpm). > If _WIN32 is defined, sqlite3odbc.c includes a "resource3.h" header file, > which is not

[sqlite] ODBC driver C source file includes a header which was not shipped

2008-04-25 Thread Abshagen, Martin RD-AS2
Hi, am trying to use the Sqlite3 ODBC driver for C, provided by Christian Werner (http://www.ch-werner.de/sqliteodbc/, product sqliteodbc-0.77-1.src.rpm). If _WIN32 is defined, sqlite3odbc.c includes a "resource3.h" header file, which is not shipped with the version. How could I work around or

[sqlite] ANN: SQLite ODBC driver version 0.77 released

2008-01-06 Thread Christian Werner
Dear all, version 0.77 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc It's Windows one-click installer is built with SQLite 3.5.4 and 2.8.17. There were two major bug fixes with respect to wide-char parameter binding and wide-char data retrieval

[sqlite] Re: sqlite ODBC?

2007-10-03 Thread Mark Wyszomierski
I suppose this is it: http://www.ch-werner.de/sqliteodbc/ is this the official driver to use though? The readme file says: "The driver is usable but may contain lots of memory leaks and all other kinds of bugs. Use it on your own risk." Anyone have any bad experiences with it? Thanks,

[sqlite] sqlite ODBC?

2007-10-03 Thread Mark Wyszomierski
Hi, Are there are ODBC drivers out there for sqlite on win32? I'm already using an ODBC library and wanted to see if I could get around rewriting everything using the native sqlite API. Thanks, Mark - To unsubscribe,

Re: [sqlite] ANN: SQLite ODBC Driver 0.73

2007-02-27 Thread Christian Werner
Noah Hart wrote: > > Hello Christian, > > I tried your odbc driver, and it works pretty well, but does not handle > Unicode at all. > > I have a "dictionary" application with two columns, first being English, > second being Punjab (stored in Unicode) > For example, simple table with > EN_WORD

RE: [sqlite] ANN: SQLite ODBC Driver 0.73

2007-02-27 Thread Noah Hart
ian Werner Sent: Sunday, February 18, 2007 11:28 AM To: sqlite-users@sqlite.org Subject: [sqlite] ANN: SQLite ODBC Driver 0.73 Hi all, release 0.73 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc >From the change log: * update to SQLite 3.3.13

[sqlite] ANN: SQLite ODBC Driver 0.73

2007-02-18 Thread Christian Werner
Hi all, release 0.73 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc >From the change log: * update to SQLite 3.3.13 * SQLGetInfo(SQL_OWNER_TERM) now is empty string * fixed bug in Win32 version concerning SQLDriverConnect() * added -L/-l/-I

Re: [sqlite] ANN: SQLite ODBC driver 0.71

2007-01-11 Thread Joe Wilson
--- Christian Werner <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > > > Hi Christian, > > > > Does your ODBC driver allow for SQLite loadable modules out of the box? > > If so, how do you specify the names of the module DLLs? > > No, the extension loading is not supported yet, although

Re: [sqlite] ANN: SQLite ODBC driver 0.71

2007-01-11 Thread Joe Wilson
Hi Christian, Does your ODBC driver allow for SQLite loadable modules out of the box? If so, how do you specify the names of the module DLLs? thanks. --- Christian Werner <[EMAIL PROTECTED]> wrote: > Howdy! > > Release 0.71 of the SQLite ODBC driver is ready for download f

[sqlite] ANN: SQLite ODBC driver 0.71

2007-01-11 Thread Christian Werner
Howdy! Release 0.71 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc (Main page) http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe (Win32 Installer) http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.71.tar.gz (Sources) The most important changes

[sqlite] [ANN] SQLite ODBC driver version 0.70

2006-08-20 Thread Christian Werner
Version 0.70 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc The Win32 installer now is made with SQLite 3.3.7. Enjoy, Christian - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] [ANN] SQLite ODBC driver version 0.68

2006-07-07 Thread Christian Werner
Version 0.68 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some more bugs mainly in the SQLite 3.x version of the driver. Enjoy, Christian

Re: AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

2006-04-04 Thread Christian Werner
[EMAIL PROTECTED] wrote: > > Hi, > > I just would like to point out that: > > - a zip-archive for the drivers ("no-install") is not provided That was my intention; is the ZIP version really necessary ? > - the documentation for sqliteodbc.c / sqliteodbc.h is missing Ditto, since SQLite

AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

2006-04-04 Thread michael.hanssen
uftrag von Christian Werner Gesendet: Montag, 3. April 2006 18:19 An: sqlite-users@sqlite.org Betreff: [sqlite] [ANN] SQLite ODBC driver version 0.67 Version 0.67 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some Unicode length issues with the SQL

[sqlite] [ANN] SQLite ODBC driver version 0.67

2006-04-03 Thread Christian Werner
Version 0.67 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some Unicode length issues with the SQLite 2.8.17 version of the driver and now fully supports binary data. The Win32 version is now made with a MinGW cross compiler and NSIS. Enjoy

[sqlite] How do I install sqlite-odbc at ARM9 target board?

2006-03-21 Thread 杰 张
Hi,all I just want to connect ASP and SQLite at ARM9 target board,but I don't known how to do it . Please help me! Thank you so much! __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com

[sqlite] Do I have to install sqlite odbc driver if I want to use ASP to connect SQLite?

2006-03-20 Thread 杰 张
Hi,all Do I have to install sqlite odbc driver if I want to use ASP to connect SQLite? If there are any available samples ,could you give me some? Thank you so much! - 雅虎1G免费邮箱百分百防垃圾信 雅虎助手-搜索、杀毒、防骚扰

Re: [sqlite] OT: patch for SQLite ODBC

2006-03-12 Thread Christian Werner
Jarl Friis wrote: > > How about just setting > PRAGMA short_column_names = off > PRAGMA full_column_names = on > withing SQLColAttribute() and SQLColAttributes() and then, before > returning from the function(s), setting it back to > PRAGMA short_column_names = on > PRAGMA full_column_names = off

Re: [sqlite] OT: patch for SQLite ODBC

2006-03-12 Thread Jarl Friis
Christian Werner <[EMAIL PROTECTED]> writes: >> >> Further I wonder what's behind the decision to use >> >> PRAGMA short_column_names = off >> >> PRAGMA full_column_names = on >> >> >> >> When using short_column_names instead (which is default), >> >> behaviour seems closer to standard Database

Re: [sqlite] OT: patch for SQLite ODBC

2006-03-09 Thread Jarl Friis
Christian Werner <[EMAIL PROTECTED]> writes: > Jarl Friis wrote: > >> I have fixed a bug in the SQLite ODBC driver. The problem is that the >> ODBC driver does not use the info from "PRAGMA table_info(...)" when >> there are no columns declared

Re: [sqlite] OT: patch for SQLite ODBC

2006-03-09 Thread Jarl Friis
ristians answer, and I suggest the discussion continues on this list until someone actually complains that the topic does not belong on the list. --- Begin Message --- Jarl Friis wrote: > Sorry for being OT, but I could not find a better place. > > I think when SQLite ODBC driver postings ar

Re: [sqlite] OT: patch for SQLite ODBC

2006-03-09 Thread Jarl Friis
Jarl Friis <[EMAIL PROTECTED]> writes: > Sorry for being OT, but I could not find a better place. > > I think when SQLite ODBC driver postings are very low-frequent, it > wouldn't hurt to (ab)use this list for that. Just to let you know. Christian has replied to me privately

[sqlite] OT: patch for SQLite ODBC

2006-03-08 Thread Jarl Friis
Sorry for being OT, but I could not find a better place. I think when SQLite ODBC driver postings are very low-frequent, it wouldn't hurt to (ab)use this list for that. Christian Werner <[EMAIL PROTECTED]> writes: > Version 0.66 of the SQLite ODBC Driver is available > on h

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-22 Thread Jay Sprenkle
On 2/21/06, Jose Da Silva <[EMAIL PROTECTED]> wrote: > On February 21, 2006 12:48 pm, Jay Sprenkle wrote: > > Sqlite has been very fast for me. If you need raw blazing > > Well, sqlite is definitely fast in relation to other sqls, but every sql > has overhead, and they all can't match direct

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-21 Thread Jose Da Silva
On February 21, 2006 12:48 pm, Jay Sprenkle wrote: > Sqlite has been very fast for me. If you need raw blazing Well, sqlite is definitely fast in relation to other sqls, but every sql has overhead, and they all can't match direct access of a flattish-file-format by a computer doing it's own

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-21 Thread Jay Sprenkle
On 2/21/06, Jose Da Silva <[EMAIL PROTECTED]> wrote: > I was a bit hesitant about using sqlite when I read elsewhere that a sql > type database is about 15x slower than direct access. > However, since this will eventually be multiuser, the > access-trashing-aspect is definitely something I want to

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-21 Thread Jose Da Silva
I was a bit hesitant about using sqlite when I read elsewhere that a sql type database is about 15x slower than direct access. However, since this will eventually be multiuser, the access-trashing-aspect is definitely something I want to avoid. :-) Thanks, that's a good suggestion. If anyone

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-21 Thread Jay Sprenkle
That might be a good way to get some basic tools over the top of the database. Access does tend to trash its database files if used by multiple users on a network. If you connect to sqlite files via odbc they should be ok though. Backup your mdb file to be safe! On 2/19/06, Jose Da Silva

[sqlite] sqlite, odbc, any gotchas?

2006-02-19 Thread Jose Da Silva
If read a bit already and see limitations and benefits in SQlite. Our office still wants to use the GUI present in MS-Access. I like the simplicity of maintaining SQLite plus it's rollback features etc. Later, there are aspirations for a webbrowser interface to same database. Anyone have

[sqlite] ODBC driver

2005-02-28 Thread Bielik, Robert
Hi, I've been trying to modify the ODBC driver (http://www.ch-werner.de/sqliteodbc/) to be able to work with BLOBs. The current 0.65 ODBC driver can only handle CLOBs (i.e. null terminated strings) inspite of it being built on sqlite3 . I've managed to get BLOB writing to work by using

[sqlite] ODBC problem

2005-02-24 Thread Bielik, Robert
Hi, I'm using the SQLite 3 ODBC driver at http://www.ch-werner.de/sqliteodbc/ and DTL (http://dtemplatelib.sourceforge.net/) and all works fine until I try to store a BLOB. I've debugged it so far that when the SQL C type is SQL_C_BINARY, no memory is allocated in SQLPutData and of course

Re: [sqlite] ODBC Driver

2004-12-23 Thread Dan Keeley
The page that gives the (very impressive) list of drivers and wrappers for SQLite is: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers The specific one you want is: http://www.ch-werner.de/sqliteodbc/ Excellent thanks! Rgds, Dan

Re: [sqlite] ODBC Driver

2004-12-23 Thread Dan Keeley
Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [sqlite] ODBC Driver Date: Thu, 23 Dec 2004 00:15:46 +0100 Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists

Re: [sqlite] ODBC Driver

2004-12-22 Thread Gerry Snyder
Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? Dan, The

Re: [sqlite] ODBC Driver

2004-12-22 Thread Oliver Bienert
Dan Keeley wrote: Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? You do not

[sqlite] ODBC Driver

2004-12-22 Thread Dan Keeley
Hi, I've finally got round to building sqlite. Now i'm after the odbc driver for it. Only thing is I can't seem to find the page on the sqlite website that lists other programs, such as an odbc driver for use with sqlite? Is there a recommended odbc driver to use? Rgds, Dan

Re: [sqlite] ODBC ADO

2004-12-21 Thread Bert Verhees
George Ionescu wrote: Hello Bert, have you tried using one of the ActiveX wrappers? I know it's not ODBC/ADO, but my wrapper (http://www.terrainformatica.com/sqlitedb) has at least an ADO-compatible interface, so that might help. I didn't want to write a full-blown ADO provider because this is

Re: [sqlite] ODBC ADO

2004-12-21 Thread George Ionescu
Hello Bert, have you tried using one of the ActiveX wrappers? I know it's not ODBC/ADO, but my wrapper (http://www.terrainformatica.com/sqlitedb) has at least an ADO-compatible interface, so that might help. I didn't want to write a full-blown ADO provider because this is the beauty of sqlite:

Re: [sqlite] ODBC ADO

2004-12-17 Thread Bert Verhees
e time. Thanks for your reaction regards Bert Verhees > SQLite components) > > Jonatan > > - Original Message - > From: "Bert Verhees" <[EMAIL PROTECTED]> > To: "SQLite" <[EMAIL PROTECTED]> > Sent: Friday, December 17, 2004 1

Re: [sqlite] ODBC ADO

2004-12-17 Thread Bert Verhees
Op donderdag 16 december 2004 16:17, schreef Clay Dowling: > Bert Verhees said: > > Does someone have experience with the ODBC-driver for SQLite3 in > > combination with the ADO layer in Delphi. > > I cannot get it to run, it stumbled about the isolation-level for > > transactions > > I don't have

Re: [sqlite] ODBC ADO

2004-12-17 Thread Jonatan Moleiro
AIL PROTECTED]> To: "SQLite" <[EMAIL PROTECTED]> Sent: Friday, December 17, 2004 10:53 AM Subject: [sqlite] ODBC ADO > Does someone have experience with the ODBC-driver for SQLite3 in > combination with the ADO layer in Delphi. > I cannot get it to run, it stumbled abo

Re: [sqlite] ODBC ADO

2004-12-17 Thread Clay Dowling
Bert Verhees said: > Does someone have experience with the ODBC-driver for SQLite3 in > combination with the ADO layer in Delphi. > I cannot get it to run, it stumbled about the isolation-level for > transactions I don't have experience with the specific situation you're describing, but if all

[sqlite] ODBC ADO

2004-12-17 Thread Bert Verhees
Does someone have experience with the ODBC-driver for SQLite3 in combination with the ADO layer in Delphi. I cannot get it to run, it stumbled about the isolation-level for transactions Thanks in advance for an answer Bert Verhees

Re: [sqlite] ODBC driver?

2004-12-14 Thread Sid Liu
Here: http://www.ch-werner.de/sqliteodbc/ --- Jay <[EMAIL PROTECTED]> wrote: > Good morning all, > > Is there an odbc driver for Sqlite3? > It would be useful to be able to use existing data > tools... > > = > > - > > The Castles of Dereth Calendar: a tour

[sqlite] ODBC driver?

2004-12-13 Thread Jay
Good morning all, Is there an odbc driver for Sqlite3? It would be useful to be able to use existing data tools... = - The Castles of Dereth Calendar: a tour of that art and architecture of the online game world of Asheron's Call

[sqlite] ANN: SQLite ODBC Driver 0.65

2004-10-07 Thread Christian Werner
Hi all, a new version of the SQLite ODBC Driver is available on http://www.ch-werner.de/sqliteodbc An unoptimized driver version supporting SQLite 3.0.7 is included. Best regards, Christian

[sqlite] ODBC Driver

2003-12-30 Thread Federico Granata
Hi, I try to find a ODBC driver to use on linux with OOo. Can you help me ? P.S. Sorry for my english. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] ODBC

2003-11-03 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: Hi all, Has anyone got SQLite working with ODBC? http://www.google.com/search?q=sqlite+odbc -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED

[sqlite] ODBC

2003-11-03 Thread [EMAIL PROTECTED]
Hi all, Has anyone got SQLite working with ODBC? I installed SQLite in Linux and I would like to access it from Windows98. Jo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Import data from a SQLite-database to Excel through SQLite-ODBC

2003-10-29 Thread Fouejieu louis
Hi Folks, please i need your help. I'm triying since 3 weeks to import some data from a SQLite-database to an excel-sheet via the interface "SQlite-ODBC"; But it's don't work. I already install an configure SQLite-ODBC and every thing is okay with MS-Query BUT! I write a makro on