AirNav Systems Forum

AirNav Radar => AirNav Radar Discussion => Topic started by: apjwright on September 26, 2009, 11:16:06 AM

Title: Tech help pls - accessing mylog.db3 from VB6
Post by: apjwright on September 26, 2009, 11:16:06 AM
Hi.  A friend of mine has a ANRB and there is a utility offered by ADQ (AeroData Quantum) that accesses the mylog.db3 database, looks up all aircraft currently on the 'MyFlights' and tells which are 'needed', which are 'scrapes', etc.

I use a different database (ADU), based on 'open' MS-Access data-model and would like to write a VB6 utility that will essentially do a similar thing to the ADQ utility.

Can anybody help me with how to 'get at' the necessary tables?  I'm thinking some kind of ODBC (or other data-access) driver that will read 'db3' tables, but have been unable to find anything so far.

TIA for any guidance and/or specific ideas.

Tony
Title: Re: Tech help pls - accessing mylog.db3 from VB6
Post by: DaveReid on September 26, 2009, 12:19:37 PM
RadarBox (like SBS/BaseStation) uses the SQLite database, for which there is an ODBC driver available.

www.ch-werner.de/sqliteodbc
Title: Re: Tech help pls - accessing mylog.db3 from VB6
Post by: apjwright on September 26, 2009, 01:02:21 PM
Thanks - will give it a try.