[Gambas-user] Microsoft Access database

[Randall Morgan]

Some ideas...

Are you running MS Access on the same system under wine? Or on a remote
machine? Do you need to actually connect to ms access or can you import the
access database in to MySQL or Postgres?

Access is actually a program. It's data-store is a file(s). Access also has
a funny query language that looks almost like T-SQL but is not quite... It
has been a long time since I did this, 2008-2009... But it was both
possible then to both connect to and import data from an Access database. I
am sure if you search and read you will find a solution. I recall the
import used mbtools. But my code is now gone and I cannot recall all the
details.

Once you know how to accomplish the task at hand, you can use GAMBAS to
program the process. Perhaps by calling mbtools or by directly accessing
the access database. Also you might find the MSSQL linux server helpful.
Never used it but it should allow serving an access data store over odbc.




On Mon, Aug 12, 2013 at 8:20 AM, nando <nando_f at ...951...> wrote:

> ACCESS db is really just a file ,and not a 'server' like MySQL
> You need software to install on your linux box to tickle the file.
> There is something out there, I did use something on a box a while back.
> (sorry forgot what is was)
>
>
> ---------- Original Message -----------
> From: Caveat <Gambas at ...1950...>
> To: gambas-user at lists.sourceforge.net
> Sent: Mon, 12 Aug 2013 14:26:54 +0200
> Subject: Re: [Gambas-user] Microsoft Access database
>
> > Not that I know of, but I have written a system to convert MSAccess
> > databases to MySQL/postgresql/MSSQLServer.  It's written in java and
> > uses the jackcess library (http://jackcess.sourceforge.net/).
> >
> > I also wrote a server which makes calls to the jackcess library based on
> > simple text commands, so in theory you could make a basic client in
> > Gambas...
> >
> > Let's first see if anyone has already found a way to talk to access dbs
> > directly in Gambas...
> >
> > Kind regards,
> > Caveat
> >
> > On 12/08/13 13:39, Ivan Kern wrote:
> > >
> > >
> > > Hi,
> > >
> > >
> > >
> > >
> > >
> > > Is it possible to connect  Microsoft access database with Gambas?
> > >
> > > If yea, please, an example.
> > >
> > >
> > >
> > > Best regards,
> > >
> > > Ivan
> > >
> > >
> ------------------------------------------------------------------------------
> > > Get 100% visibility into Java/.NET code with AppDynamics Lite!
> > > It's a free troubleshooting tool designed for production.
> > > Get down to code-level detail for bottlenecks, with <2% overhead.
> > > Download for free and get started troubleshooting in minutes.
> > >
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> > > _______________________________________________
> > > Gambas-user mailing list
> > > Gambas-user at lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > >
> >
> >
> ------------------------------------------------------------------------------
> > Get 100% visibility into Java/.NET code with AppDynamics Lite!
> > It's a free troubleshooting tool designed for production.
> > Get down to code-level detail for bottlenecks, with <2% overhead.
> > Download for free and get started troubleshooting in minutes.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> ------- End of Original Message -------
>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>



-- 
If you ask me if it can be done. The answer is YES, it can always be done.
The correct questions however are... What will it cost, and how long will
it take?