Re: Accessing .mdb files residing on a linux box with the DBI
On Sat, 7 Sep 2002, Moritz von Schweinitz wrote: ... > i'd really, reallt like my program to run on that box. > does anybody have an idea how i can accomplish this without having to > ask some windows-machine to tell me what's inside that DB? i'd be > perfectly happy with read-only access, if that makes a difference. do a Google search for MDBtools. UNIX utilities for reading the innards of ..mdb files ;) --- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc.
Re: Accessing .mdb files residing on a linux box with the DBI
Curt, I was trying to do just was you suggested to Moritz back in Feburary. Could you post the dbi code you used to connect to the database because I couldn't connect at the time. I didn't know mysql back then either though so I should try it now that I've been using Dbi since April. Since this became a topic I wanted to ask for the code since I'm going to run into the same problem in a few weeks as well. Thanks, Tony
Re: Accessing .mdb files residing on a linux box with the DBI
Seems to read Access files in UNIX is in the "Project Unix", you may check their progress here: http://sourceforge.net/projects/mdbtools --- Curt Russell Crandall <[EMAIL PROTECTED]> wrote: > The *.mdb file IS the Access database. I've tried a > couple of ways to > read it on a UNIX system and nothing worked. Your > best bet is to set up a > similar scheme on a database that sits on your Linux > box (i.e. Postgres, > MySQL, etc). On the Windows machine, load Perl > (like ActiveState > Perl) with DBI, and drivers and client libs for your > target DB. Make a > Perl script to select * and then as your loop > through your result set, > insert it into the target DB. > > If someone has a way to directly read Access > databases on a *NIX system, > I'd love to hear about it. It's been a while, but I > think using DBI Proxy > to connect to an Access DB on windows was one way to > do it. > Even if a method like that worked, I think you'd > eventually want to scrap > using Access altogether and use a real DB that > resides on your Linux box. > > HTH > Curt > > On Sat, 7 Sep 2002, Moritz von Schweinitz wrote: > > > hi, > > > > i have access a database that's stuck (poor thing > ;-) inside a .mdb > > file, and resides on a linux machine via the DBI. > the linux-box is a > > file-server, and the clients access the database > via samba (why would > > anybody do it that way??! i simply don't get it). > > > > i'd really, reallt like my program to run on that > box. > > does anybody have an idea how i can accomplish > this without having to > > ask some windows-machine to tell me what's inside > that DB? i'd be > > perfectly happy with read-only access, if that > makes a difference. > > > > any help is very appreciated, > > > > M. > > > > > __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com
Re: Accessing .mdb files residing on a linux box with the DBI
The *.mdb file IS the Access database. I've tried a couple of ways to read it on a UNIX system and nothing worked. Your best bet is to set up a similar scheme on a database that sits on your Linux box (i.e. Postgres, MySQL, etc). On the Windows machine, load Perl (like ActiveState Perl) with DBI, and drivers and client libs for your target DB. Make a Perl script to select * and then as your loop through your result set, insert it into the target DB. If someone has a way to directly read Access databases on a *NIX system, I'd love to hear about it. It's been a while, but I think using DBI Proxy to connect to an Access DB on windows was one way to do it. Even if a method like that worked, I think you'd eventually want to scrap using Access altogether and use a real DB that resides on your Linux box. HTH Curt On Sat, 7 Sep 2002, Moritz von Schweinitz wrote: > hi, > > i have access a database that's stuck (poor thing ;-) inside a .mdb > file, and resides on a linux machine via the DBI. the linux-box is a > file-server, and the clients access the database via samba (why would > anybody do it that way??! i simply don't get it). > > i'd really, reallt like my program to run on that box. > does anybody have an idea how i can accomplish this without having to > ask some windows-machine to tell me what's inside that DB? i'd be > perfectly happy with read-only access, if that makes a difference. > > any help is very appreciated, > > M. > >
Accessing .mdb files residing on a linux box with the DBI
hi, i have access a database that's stuck (poor thing ;-) inside a .mdb file, and resides on a linux machine via the DBI. the linux-box is a file-server, and the clients access the database via samba (why would anybody do it that way??! i simply don't get it). i'd really, reallt like my program to run on that box. does anybody have an idea how i can accomplish this without having to ask some windows-machine to tell me what's inside that DB? i'd be perfectly happy with read-only access, if that makes a difference. any help is very appreciated, M.
