RE: ODBC + MSAccess + Perl + Linux or FreeBSD question.

From: Dennis M. Gray (d0325mgray_at_fareast.com.au)
Date: 03/24/04 

To: "'David Claughton'" <dclaughton@intechsolutions.co.uk>, <dbi-users@perl.org>
Date: Wed, 24 Mar 2004 23:58:37 +1100

David,

There are many issues that must be considered before one can make a
generalised statement that the data should be transferred. I am not
especially fond of MS Access as a DBMS but it has a reasonable UI and
can link to other databases via ODBC. In my situation, I develop test
data on an Oracle databases and have many link tables in MS Access.
Oracle is the production database for the government agency I work for
and I am not about to change that. I have local Access tables that I use
for conversion and other data manipulations and it works fine.

I used the DBI::ODBC on Windows to create large amounts of test data by
reading my MS Access tables.

I also use the DBI::Oracle to extract other sets of test data and
reformat for input into a legacy system.

I use MS Access with ODBC to link my mySQL tables from another
application.

I use PHP and mySQL for a website I have developed but a lot of the
testing is still done using MS Access and ODBC.

I have not used any UNIX ODBC drivers yet.

Regards,

Dennis

-----Original Message-----
From: news [mailto:news@sea.gmane.org] On Behalf Of David Claughton
Sent: Wednesday, 24 March 2004 8:42 PM
To: dbi-users@perl.org
Subject: Re: ODBC + MSAccess + Perl + Linux or FreeBSD question.

I would be inclined to dump MSAccess and transfer the data to an
Open-Source database (e.g. MySQL www.mysql.com ) instead.

MySQL has a Windows version as well, so you should be able access the DB
in both environments, if that is a requirement.

Regards,

    David.

"Ricardo Pichler" <linux@pichler.com.br> wrote in message
news:20040319040151.52517.qmail@onion.perl.org...
> Hi everyone,
> I'm try to make this work: perl + unixodbc +
> MSAccess but I can't"
>
> Anybody make this work? Or others ways to read and
> write access file with perl in linux or freebsd?
>
> Thank's in advance!
> --
> Ricardo Pichler
>

Relevant Pages

  • Re: Standard DBI Proposal
    ... If you're asserting that there is no ODBC on non-Windows platforms, ... Tcl command I can use to connect, ... This is what tclodbc does and I think ... My two workhorse databases are ...
    (comp.lang.tcl)
  • RE: ODBC logging via ISS Internet Scanner
    ... Here is a synopsis of the situation: I want ISS ... I have a ODBC connection to this MySQL ... > Check out Yahoo! ...
    (Security-Basics)
  • Re: Native ODBC access for python on linux?
    ... Can you tell me what I have to use in order to utilize the MySQL native ... > ODBC is a vanilla interface that puts a layer between the program ... The native API can provide access to all ... >> I'm getting my feet wet with making Python talk to MySQL via ODBC. ...
    (comp.lang.python)
  • RE: [PHP] Microsoft .NET arguement
    ... You can't interface MySQL with ODBC? ... I've found MS SQL (and MS Access databases) to be extremely fast ...
    (php.general)
  • Suse8.1 howto: MySQL under OOo using ODBC - got it to work, but ...
    ... I'm still trying to get a working MySQL data entry setup under linux. ... Google -> right, have to install x-devel. ... Database source: ODBC ... ODBC data source configuration is not available. ...
    (alt.os.linux.suse)