Re: defining a DSN for Access on Linux

On 9/29/06, Justin Findlay <justin@xxxxxxxxxxx> 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
--------------------------------------------------------------------------------------------------------------
.

Relevant Pages

  • Re: DBD::DB2 question need an example
    ... means that DB2 is not liking something about your $dsn. ... un-cataloged database. ... They who would give up an essential liberty for temporary security, ...
    (perl.dbi.users)
  • Re: [SLE] SQUID Setup
    ... > Im new at SUSE/Linux, ... > I am trying to set up a proxy to speed my dial up access. ... "They that can give up essential liberty to obtain a little ... temporary safety, ...
    (SuSE)
  • Re: Problem getting Perl - SQL Server connect working - syntax error?
    ... My bad for just spotting syntax and not thinking about ODBC. ... create a DSN-less connection, but the syntax amounts to creating a DSN ... They who would give up an essential liberty for temporary security, ...
    (perl.dbi.users)
  • Re: Interesting Quotes.............{NDC}
    ... They that can give up essential liberty to obtain a little temporary ... safety deserve neither liberty nor safety. ... proxy for our Founding Fathers... ...
    (rec.music.gdead)