[Gambas-user] accessing mdb files

[Caveat]

It's perhaps a little off-topic as this is a Gambas mailing list, but I 
have written a .mdb to mysql|postgresql|hsqldb|mssqlserver converter in 
java.  I tried using mdbtools but never got very satisfactory results, 
so I wrote my own conversion software.

The converter works on Northwind (the sample .mdb from MS), including 
the binary pictures and on our own database we use for stock control at 
work (150,000 records or so, takes about 5 mins...).  There is support 
for complete conversion of the schema (create all tables, columns with 
null/not null, create primary keys, indexes, foreign key relations, ...) 
and of course, the all-important data!

I'm looking to test against a few more databases, so if this is an 
interesting route to follow, don't hesitate to contact me directly.

I also support a kind of basic "interactive mode" through a socket where 
you can retrieve rows, do simple selects, examine columns etc.  The 
conversion is done using only commands which are also available as 
interactive commands...

Kind regards,
Caveat

On 27/08/13 10:32, Fernando wrote:
> On Aug 26, 2013 21:34 "Willy Raets" <willy at ...2734...> wrote:
>
>> I made a small example project that makes a connection to a .mdb
>>
>> This is how it is possible (I only tested the connection, not reading
>> in
>> tables or changing any records):
>>
>>
> perhaps you missed my initial email, that's what I did based on an older
> email on this list. The problem is, apparently, not the connection but
> the retrieving of data.
>
> Regards,
> Fernando
> ------------------------------------------------------------------------------
> Introducing Performance Central, a new site from SourceForge and
> AppDynamics. Performance Central is your source for news, insights,
> analysis and resources for efficient Application Performance Management.
> Visit us today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>