Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: MS Access DB

by tjh (Curate)
on May 19, 2002 at 12:50 UTC ( #167649=note: print w/replies, xml ) Need Help??


in reply to 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?

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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://167649]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (2)
As of 2019-08-21 00:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?