Murray Moffatt wrote:
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.You have two choose:
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/_ 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?
1. search the windows register for the datasource that you created using ODBC Control Panel, you can create the same register entry programmatically.
2. You can just use such a string as your ConnectionString "Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=;"
Please replace the Driver,Dbq and so on to the real values used by SQLite ODBC, as in choose 1 you can get them from the register.
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
------------------------------------------------------------------------
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
------------------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--
Best Regards
______
/_____/\ Wind Li
/____ \\ \ Sun Microsystems
/_____\ \\ / Email: [EMAIL PROTECTED]
/_____/ \/ / / Tel: (8610)82618200 ext.82962
/_____/ / \//\ Fax: (8610)62780969
\_____\//\ / / Cel: 13691555880
\_____/ / /\ /
\_____/ \\ \ China Engineering & Research Institute
\_____\ \\ 10/F, B ChuangXin Plaza
\_____\/ Beijing 100084, P.R.China--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
