Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Can I interface MS Access on Unix?

( #69509=categorized question: print w/ replies, xml ) Need Help??
Contributed by Anonymous Monk on Apr 04, 2001 at 03:58 UTC
Q&A  > database programming


Description:

Load up Access to UNIX and connect to it in UNIX, since there is an ODBC Driver?

Answer: Can I interface MS Access on Unix?
contributed by Coyote

I don't know of any way to access and Access databased directly from Unix, however if you have a networked Windows box available, you can use the DBI::ProxyServer module from CPAN in conjunction with <a href='http://search.cpan.org/search?mode=module&query=DBD%3A%3AODBC>DBD::ODBC to set up a simple database server for the Access database on the Windows machine. You can now use the DBD::Proxy driver in a script on the Unix side to access the database just like you would any other DBI compatible datasource. Its ugly, round about solution but it works.

Answer: Can I interface MS Access on Unix?
contributed by LucidMatrix

This is slightly round about, but it works, I've done it for quick demos of this and that.

Use MySQL and create all of your tables in this. the same SQL statments can create the tables in ACCESS later, so you aren't wasting efforts.

Install the ODBC MySQL client on the windows machine, and connect it to the Unix database on the server.

Now, connect, don't import, .. connect/link in Access each of the data files you want to use in your ACCESS program.

That's it. Any information changed on the MySQL server will now also be live on your MS Access server. A small warning, MS Access will never give you the performace that you will have on the server with MySQL, but you can write all of the VB progarms you want and they will treat the linked data files just like Access data files.

Hope this helps and good luck

Answer: Can I interface MS Access on Unix?
contributed by jorg

Wouldn't think you can access Access from Unix through ODBC.. (please correct me if this has been done.. a quick search didn't return anything usefull).
How about the following : you run an IIS (or your choice of webserver) on that windows machine with a CGI script (perl ofcourse (: ) that accepts a query/odbc name as parameters, then goes off to query your access database through DBD::ODBC and returns you a resultset delimited and separated as whatever you want.

Answer: Can I interface MS Access on Unix?
contributed by hacker_j99

Currently you can use FreeTDS ( with some tweaks) or Sybase and use DBD::SYBASE insead of DBD::ODBC...

Please (register and) log in if you wish to add an answer



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • 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, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            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.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others studying the Monastery: (3)
    As of 2014-07-10 03:35 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      When choosing user names for websites, I prefer to use:








      Results (198 votes), past polls