[Gambas-user] Microsoft Access database

Tue Aug 13 15:18:58 CEST 2013

Here's how to setup ODBC for Access and MSSQL Server:
http://office.microsoft.com/en-us/access-help/administer-odbc-data-sources-HA010275550.aspx

On Tue, Aug 13, 2013 at 6:14 AM, Randall Morgan <rmorgan62 at ...626...> wrote:

> Ok,
>
> Simplest solution is to install MSSQL Server (personal version should
> work) and follow directions for accessing an Access data store via MSSQL
> Server (Lots of info on the net).  Then Connect to the SQL server over the
> network.
>
>
> On Tue, Aug 13, 2013 at 5:57 AM, Ivan Kern <ivan-kern at ...308...> wrote:
>
>> 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
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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?
>

-- 
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?