Re: Can I interface MS Access on Unix?

[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.

[Chmrr]

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'

[jorg]

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