Re: MS Access DB

The concept of uploading a bank-generated data file of any type to a publicly available web server shocked me right out of my early morning stupor. Surely I'm misunderstanding what you're thinking.

Wouldn't it be better to access the mdb file from Perl installed on your local workstation that's off the public net? Even if you are storing other data on the web server that you're using the bank's file to validate or update, you could build your update offline and run it or feed it to the cgi on the web server eh (or download data from the web server to the local machine for processing)? (egads, now I'm starting to wonder about what other data is stored on the web server...)

As for using Perl to read the .mdb file, did you look at DBI's DBD::ODBC driver discussed in the FAQ?

Comment on Re: MS Access DB

Replies are listed 'Best First'.
Re: Re: MS Access DB by daveime (Novice) on May 19, 2002 at 13:34 UTC
Now don't panic .... what I was trying to explain (somewhat poorly) is that I will be uploading this MDB file (which only contains an updated list of all the SWIFT codes, names and addresses etc of the European banks.), to somewhere in the cgi-bin or level ... I wouldn't be thinking of putting it at htdocs public access level !! Regarding using the DBD:ODBC driver ... how will this work when our server is a Redhat 7 ? We don't have any MS Jet drivers or any way for the ODBC to communicate with the .mdb file format ? I was hoping that someone has some suggestion involving "MDB Tools" or "FreeTDS" which seem to be the only ways to read an .mdb file located on a Redhat box.	[reply]
(sparkyichi)Re: MS Access DB by sparkyichi (Deacon) on May 19, 2002 at 17:30 UTC
On a side note, putting it in the cgi-bin will not make it any more secure or less public. I have not done much work with Access Databases or database work on Linux, but I have worked with Oracle on Dynix. Working from the Unix server that the database is hosted on is no problem, but Access is another ball of wax. Here is a good link that covers access databases. I would think that it work fairly the same between Linux and Windows. Sparky FMTEYEWTK	[reply]