This is not MSSQL, this is MS Access (JetDB engine). I have searched.. for several days and at many sites. When it comes to Windows (Active State) Perl, it's dead simple to install Win32::ODBC, set up the DSN connection, and it works.
When I try to figure out where to even start on Linux, it's much more confusing. Apparently Perl needs an ODBC interface (DBI), an ODBC driver (???), and then an ODBC manager (unixODBC). The ODBC driver is the sticking point. So far, I have only found EasySoft's ($700+) driver to allow an ODBC connection to MS Access. This doesnt make any sense to me. I would think that once I have set up an ODBC connection (DSN) on the Windows box, I shouldnt need any special driver! It's *OPEN* DBC!
Anyway, you can see how ignorant I am on this topic, and any links to educate me would be appreciated. Here's where I am getting my info:
http://www.easysoft.com/developer/languages/perl/sql_server_unix_tutorial.html

I'm not sure why I need the ODBC-ODBC bridge software. It seems redundant. Why do we need a bridge to join the same open standard?
The closest I have found to a similar problem here on Perl Monks is this node:
http://www.perlmonks.org/?node_id=419398
but they have local access to the .mdb file, which I do not. I don't think MDBTools will help me.

Thank you for trying to help and providing those links.

In reply to Re^2: Linx Perl ODBC connect to MS Access by kenk
in thread Linx Perl ODBC connect to MS Access by kenk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.