Hi, I have been running an Access DB on a Win2K box, and using perl to
populate an LDAP server on a Solaris server. The standard perl/DBI
distribution on the Windows machine comes with something called
DBI::Proxy. You run it as a daemon on the Windows box and any Unix based
perl script using DBI can see any ODBC data-sources available there. I
have been told by some people with more distributed DB experience that in
the end it is more efficient to migrate all data to a single server,
rather than deal with it being both in Access and some local SQL server.
such as MySQL.
Hope this helps,
Alex
On Tue, 18 Sep 2001, Brice D Ruth wrote:
> Am I assuming correctly, that Perl could communicate with a MS Access
> database file via ODBC, on a Windows box? If so, are there any
> particular gotchas or limitations to this approach that I should be
> aware of? I typically use MySQL or PostgreSQL on a Linux or FreeBSD
> box, so this is sorta new to me. Also, is it possible for iODBC to
> communiate with a MS Access database file on a Linux box? Is there any
> way to do this? If, e.g. I wanted to setup Apache + mod_perl on a Linux
> box to access a local Access database file - what would I need? Or is
> this not possible?
>
> Any guidance is as always, appreciated :)
>
> -Brice
>
>
>
