Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Answer: Can I interface MS Access on Unix?

( #69917=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > 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.

Comment on Answer: Can I interface MS Access on Unix?
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

      Jorg

      "Do or do not, there is no try" -- Yoda
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 wandering the Monastery: (7)
As of 2014-09-03 04:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (35 votes), past polls