Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Answer: Can I interface MS Access on Unix?

by jorg (Friar)
on Apr 05, 2001 at 02:13 UTC ( #69917=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > Can I interface MS Access on Unix? - Answer 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.

  • Comment on Answer: Can I interface MS Access on Unix?
Replies are listed 'Best First'.
Re: Answer: Can I interface MS Access on Unix?
by Chmrr (Vicar) on Apr 05, 2001 at 03:02 UTC

    A (hopefully obvious) note: Be wary of the security implications of this. Having someone get to that CGI script, and give it "select credit_cards from users" would really ruin your day.

    perl -e 'print "I love $^X$\"$]!$/"#$&V"+@( NO CARRIER'

      very true.. i was more thinking that this would be an intranet application but yes even so it would be unwise to let anyone access the data without adding an extra layer of security on top of it


      "Do or do not, there is no try" -- Yoda
Log In?

What's my password?
Create A New User
[choroba]: :-) sweet? The main ingredients are vinegar and onion

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2017-11-21 11:15 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (297 votes). Check out past polls.