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 <rmorga...@gmail.com> 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-k...@freenet.de> 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:rmorga...@gmail.com] >> Gesendet: Dienstag, 13. August 2013 00:11 >> An: nand...@nothingsimple.com; 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 <nand...@nothingsimple.com> 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 <gam...@caveat.demon.co.uk> >> > To: gambas-user@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@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@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@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@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@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? ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
