Re: [Gambas-user] accessing mdb files

2013-08-31 Thread Caveat
The software directly accesses the mdb file, using the jackcess library (http://jackcess.sourceforge.net/), so no Access nor Windoze required. I haven't worked out all the licensing yet (it builds on a few other java libraries too) so I'm not yet ready to release the code publicly. What I'm

Re: [Gambas-user] accessing mdb files

2013-08-30 Thread Fernando Martins
On 08/29/2013 07:51 PM, Caveat wrote: 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.

Re: [Gambas-user] accessing mdb files

2013-08-30 Thread Fabien Bodard
is your converter free ? (GPL ?) 2013/8/30 Fernando Martins ferna...@cmartins.nl On 08/29/2013 07:51 PM, Caveat wrote: 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

Re: [Gambas-user] accessing mdb files

2013-08-27 Thread Fernando
On Aug 26, 2013 21:34 Willy Raets wi...@earthshipbelgium.be 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

[Gambas-user] accessing mdb files

2013-08-26 Thread Fernando Martins
Hi, Has anyone been able to access .mdb files? I tried with ODBC but got to the same stage reported here: http://gambas.8142.n7.nabble.com/Seg-fault-rev-3903-odbc-db-selecting-td4746.html i.e., no errors in connection, but no data back from a simple select. Regards, Fernando

Re: [Gambas-user] accessing mdb files

2013-08-26 Thread Randall Morgan
Linux does not have direct support for mdb as far as I am aware. Under Linux, you would need to either locate a an access driver for odbc or use something like Jackcess in Java middle-ware to access the db. There are other possibilities such as running MSSQL on a windows machine and remotely

Re: [Gambas-user] accessing mdb files

2013-08-26 Thread Fernando Martins
On 08/26/2013 07:39 PM, Randall Morgan wrote: Linux does not have direct support for mdb as far as I am aware. There is mdbtools, which includes a primitive odbc driver, that I was trying to use. http://mdbtools.sourceforge.net/ Regards, Fernando

Re: [Gambas-user] accessing mdb files

2013-08-26 Thread Willy Raets
On Mon, 2013-08-26 at 21:23 +0200, Fernando Martins wrote: On 08/26/2013 07:39 PM, Randall Morgan wrote: Linux does not have direct support for mdb as far as I am aware. There is mdbtools, which includes a primitive odbc driver, that I was trying to use.