http://www.perlmonks.org?node_id=131130

chiller has asked for the wisdom of the Perl Monks concerning the following question:

I have been reading thru the articles w/r/t ADO and ODBC and getting thoroughly confused.

Is this even possible? I need to connect to a Microsoft Access database on an NT machine without an ODBC Data Source control panel. I cannot set up a DSN. This is not the way I'd like it, but for paranoid security reasons, that is just the way it is.

I have looked at Win32::OLE and DBI::ADO and these all seem to require a DSN. I cannot use any ODBC anything, for obvious reasons.

Short of redesigning the Access DB to export information to CSV, what are possible solutions?

Thanks.