defining a DSN for Access on Linux

Is it possible to connect to an MS access database on windows from a
linux machine using DBD::ODBC without needing unixODBC? Would I need to
first set up a system DSN on the windows machine or according to the
DBD::ODBC documentation can I connect without a 'full' DSN, whatever
that is? Something like:

my $DSN = 'server,port,database name,driver,whatever else goes here';
my $dbh = DBI->connect('dbi::ODBC:$DSN');

What would a well formed DSN look like in this situation if it were
possible, or where can I find intelligible documentation? The
documentation in DBD::ODBC on DSN's is nearly occult to me. I cannot
seem to find any reasonable documentation on the web, only random
examples that betray clues as to the DSN's structure but don't do nearly
what I need.


Justin

Re: defining a DSN for Access on Linux

On 9/29/06, Justin Findlay wrote:
> Is it possible to connect to an MS access database on windows from Linux

To the best of my knowledge, MS Access provides no listener capable of
accepting connections without an ODBC DSN being present. However, you
can set up a DBI proxy on the windows machine and use DBD::Proxy to
connect. A DSN needs to be available to the proxy server, whether it's
a system or a user DSN is up to you. DBD::ODBC must also be present
and available to the proxy server. All that you need to know to set
this up can be found in the perldocs for DBD::Proxy and
DBD::ProxyServer.

--
------------------------------------------------------------ --------------------------------------------------
The darkest places in hell are reserved for those who maintain their
neutrality in times of moral crisis.
Dante Alighieri (1265 - 1321)

They who would give up an essential liberty for temporary security,
deserve neither liberty or security.
Benjamin Franklin

Our lives begin to end the day we become silent about things that matter.
Martin Luther King

The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no warrants shall issue, but upon probable cause,
supported by oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.

Amendment IV to the Constitution of the United States
------------------------------------------------------------ --------------------------------------------------

Re: defining a DSN for Access on Linux

All that you need to know to set
> this up can be found in the perldocs for DBD::Proxy and
> DBD::ProxyServer.
>
Correction: DBI::ProxyServer
--

------------------------------------------------------------ --------------------------------------------------
The darkest places in hell are reserved for those who maintain their
neutrality in times of moral crisis.
Dante Alighieri (1265 - 1321)

They who would give up an essential liberty for temporary security,
deserve neither liberty or security.
Benjamin Franklin

Our lives begin to end the day we become silent about things that matter.
Martin Luther King

The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no warrants shall issue, but upon probable cause,
supported by oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.

Amendment IV to the Constitution of the United States
------------------------------------------------------------ --------------------------------------------------