Siegfried Heintze wrote:
Is there an example somewhere of accessing an MSAccess database from a SuSE
or RedHat machine via perl DBI?
Here is what I am presently using with ActiveState Perl to access the
MSAccess database on windows:
my $dbh = DBI->connect("dbi:ODBC:driver={Microsoft Access Driver
(*.mdb)};dbq=c:\\database.mdb","Admin","") or die "$DBI::errstr\\n";
What would I change to make this work on SuSE or RedHat?
Thanks,
Siegfried
Siegfried,
There are few options, unless MSAccess has come so far as being able to
be served on a port number as a server? I don't know that, I don't use
MSAccess. As far as I know, MSAccess is an "application" and doesn't
have the robustness of a Database Server, like PostgreSQL/Oracle/MS
SQL/Sybase/... other servers that can be accessed remotely by listening
on a determined IP/Port pair.
If you can get your MSAccess 'db' listening to a port number on your
Windows box, suffice it to say that you have the DBI driver installed on
the Linux (Suse/Redhat) box too for MSAccess, then you can use DBI to
connect to any remote DB server. I'm not sure if the DBI MSAccess
driver supports remote connections, again this is really a question of
"what can MS Access do?"
I'd recommend migrating your MS Access data over to the Linux box if
that's what you intend on using for the future. To do this, you'd have
several methods.
What are your plans?
