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
