Hi Murray, Can I make a suggestion or two. Firstly I wouldn't use Crystal Report. It sucks and I hate it , have a look at ActiveReports from DataDynamics Version 2.0 is fantastic and very light on it's feet (small). The price is great as well. Also ActiveReport supports ADO , DAO, RDO and XML. You can pragmatically send it a array and bind to that. With the ODBC driver, I'm not a big fan of installing drivers (ODBC) during setup or supplying them with the application. That's why the wrapper I wrote doesn't use them. A & G Software Quality software with Style
Greg Obleshchuk Partner A & G Software Victoria Australia [EMAIL PROTECTED] http://www.ag-software.com <http://www.ag-software.com/> MSN: [EMAIL PROTECTED] <http://www.ag-software.com/ags_scribe_index.aspx> Document any Microsoft database in minutes <http://www.ag-software.com/xp_ags_crosstab.aspx> Generate Cross tab results from Microsoft SQL Server 2000 _____ From: Murray Moffatt [mailto:[EMAIL PROTECTED] Sent: Monday, 17 May 2004 2:14 PM To: [EMAIL PROTECTED] Subject: RE: [sqlite] sqlite with Visual Basic I'm interested in using SQLite from within a Visual Basic 6 app that I'm writing. I need reporting features and so was looking at using Crystal Reports. I'm guessing that it would be easiest to use SQLite ODBC for accessing the SQLite database, as the VB tools and Crystal Reports support ODBC. When I downloaded SQLite ODBC from <http://www.ch-werner.de/sqliteodbc/> http://www.ch-werner.de/sqliteodbc/ and looked at the readme file I was a bit concerned when I read that this was still "experimental". Obviously if I want to distribute my app to others I want something that isn't going to bomb out every so often! If anyone else is using SQLite ODBC in an app I'd like to hear how stable it is? Also the readme file says that it has to be installed and databases set up by using the ODBC Control Panel applet. Obviously I don't want to have to tell people that they have to set all this up themselves by hand after they install my app, so is there any way I can programmatically set up the ODBC connection? Either via my installation program or within the main app itself? At 20:32 16/05/2004 +0200, you wrote: Personally, I use my own wrapper (attached) with Greg Obleshchuk's AGS_SQLite.dll. It is very simple to use (it will generate the SQL code for you): Dim db as ADOSQLite Set db = new ADOSQLite db.Connect "database.db" db.Table = "mytable" db.Action = ActionSelect db.Sort = "id" db.Where = "id < 100" db.Exec If Not db.Err Then do while not db.EOF debug.print db.field("id") db.MoveNext Loop End if Of course this runs "in-memory" so if this is a concern for you, then try to narrow down your selects. Cheers! Chris > -----Original Message----- > From: Raymond Irving [mailto:[EMAIL PROTECTED] > Sent: 14 May 2004 17:50 > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] sqlite with Visual Basic > > > I use SQLite ODBC with ADO to access databases from VB. It > works like a charm. > > http://www.ch-werner.de/sqliteodbc/ > > __ > Raymond Irving > > > Jérôme_VERITE <[EMAIL PROTECTED]> wrote: > I use this wrapper and to simplify again the code, I created > littles classes which are very simple and look like the DAO > classes. It permits to transform Simply a VB application > using DAO to SQLITE > > Jérôme > > -----Message d'origine----- > De : Steve O'Hara [mailto:[EMAIL PROTECTED] > Envoyé : vendredi 14 mai 2004 10:35 > À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED] > Objet : RE: [sqlite] sqlite with Visual Basic > > > Here's the SQLite wrapper for VB from the Yahoo groups........ > > Steve > > -----Original Message----- > From: Jalil Vaidya [mailto:[EMAIL PROTECTED] > Sent: 14 May 2004 02:13 > To: Carlos Garces; [EMAIL PROTECTED] > Subject: Re: [sqlite] sqlite with Visual Basic > > > There is a VBWrapper.zip in the old SQLite yahoo > group's file section. The archive contains wrapper > over the SQLite API so that it can be used from VB. > The API declarations for VB are also in the archieve. > Get it from here: > > http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q- > 4gKNXEFX9QQmKI > vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper > > If you cannot download from the link above then you > will have to join the group to get it. > > HTH, > > Jalil Vaidya > > Disclaimer: I have never used this wrapper myself. > > --- Carlos Garces wrote: > > Hi! > > I can use SQLLite with Visual Basic without using > > other external DLL > > Any sample of using sqlite.dll API? > > > > Thanks > > Carlos Garcis > > > ===== > 01001010 > 01100001 > 01101100 > 01101001 > 01101100 > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Movies - Buy advance tickets for 'Shrek 2' > http://movies.yahoo.com/showtimes/movie?mid=1808405861 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com <http://www.grisoft.com/> ). > Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004 > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com <http://www.grisoft.com/> ). Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Regards Murray