[Gambas-user] Microsoft Access database

[Ivan Kern]

I thank you all.

I'm running MS Access on the remote machine and I need actually connect to
MS access.
I still have no solution.

Kind regards,
Ivan

-----Ursprüngliche Nachricht-----
Von: Randall Morgan [mailto:rmorgan62 at ...626...] 
Gesendet: Dienstag, 13. August 2013 00:11
An: nando_f at ...951...; mailing list for gambas users
Betreff: Re: [Gambas-user] Microsoft Access database

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.c
> lktrk
> > > _______________________________________________
> > > 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.c
> lktrk
> > _______________________________________________
> > 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.c
> lktrk _______________________________________________
> 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?
----------------------------------------------------------------------------
--
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