Re: [sqlite] ODBC ADO
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: you can have a whole database engine by delivering a single file to the client. Best regards, George Ionescu
Re: [sqlite] ODBC ADO
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 the beauty of sqlite: you can have a whole database engine by delivering a single file to the client. Best regards, George Ionescu I could not find it on the website, does it support sqlite 3.0x? Bert
[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 about the isolation-level for transactions Thanks in advance for an answer Bert Verhees
Re: [sqlite] ODBC ADO
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 you need is Delphi access I highly recommend the Zeos Database Objects at http://www.zeoslib.net. The latest beta is SQLite capable, at least for SQLite 2.8.x Connecting through ODBC via ADO just seems like way too many layers to be comfortable. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
Re: [sqlite] ODBC ADO
Try one of these: Aducom http://www.aducom.com/sqlite/ (Suppor 2.x and 3.x) Zeos http://www.zeoslib.net/ (Suppor 2.x) Other: http://www.torry.net/pages.php?id=561 (Some components for access SQLite components) Jonatan - Original Message - From: Bert Verhees [EMAIL 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 about the isolation-level for transactions Thanks in advance for an answer Bert Verhees
Re: [sqlite] ODBC ADO
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 experience with the specific situation you're describing, but if all you need is Delphi access I highly recommend the Zeos Database Objects at http://www.zeoslib.net. The latest beta is SQLite capable, at least for SQLite 2.8.x I need support for 3.x, because of the fact that 2.8.x does not use indices when there is an OR in the WHERE part in the same table. I know UNION could help, but I have to deal with live-generated SQL-statements. Connecting through ODBC via ADO just seems like way too many layers to be comfortable. Me too, thanks for the tip. BTW did you notice that none of the links on that site seems to work. A bug, I guess. Kind regards Bert Verhees Clay Dowling -- met vriendelijke groet Bert Verhees ROSA Software
Re: [sqlite] ODBC ADO
Op vrijdag 17 december 2004 16:33, schreef Jonatan Moleiro: Try one of these: Aducom http://www.aducom.com/sqlite/ (Suppor 2.x and 3.x) This database-component is not recognized as a database-component in the Bold MDA-layer (model driven architecture), so I cannot us it. But I used this component to write a dbXpress driver, I am halfway with it, but I have lack of time Zeos http://www.zeoslib.net/ (Suppor 2.x) See previous mail. Other: http://www.torry.net/pages.php?id=561 (Some components for access I cannot find anything usefull. on Torry.net I used to use the dbXpress driver of Marco Wobben, but he did not update it for a long time, that is why I want to write a new one which is not that hard, but I do not have much time, that is the problem. At this moment there is not a for me useful Delphi layer to SQLite. So I have to use another db, for the 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 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 about the isolation-level for transactions Thanks in advance for an answer Bert Verhees -- met vriendelijke groet Bert Verhees ROSA Software