Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

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
[Discipulus]: good morning choroba! the eu-crew is complete! ;=)
mxb waves

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (10)
As of 2018-05-21 08:08 GMT
Find Nodes?
    Voting Booth?