Database Interrogation

[pwel]

I am a HND student and relatively new to JavaScript. <br>
<br>
My question concerns accessing various databases from a company Intranet, in particular, Access, Fox Pro and Oracle. I would like to run queries and perform simple searches on the information contained in these databases from the web browser.<br>
<br>
Is it a combination of SQL and JavaScript that I need to use?<br>
Are there any software packages to help in this area?<br>
<br>
Any help with this issue would be much appreciated.<br>
<br>
Paul Welding.<br>

 

[rycamor]

Javascript doesn't have any direct methods to connect to a database. That's because Javascript is strictly a client-side only language, and does not have the right to execute programs on a server. Javascript is excellent at doing useful things with the data once the browser has received it, though, such as holding arrays in memory, etc...<br>
<br>
What I would recommend for your situation is to research PHP (there is a forum here) and learn more about ODBC, which can connect PHP to many database applications.

 

[rjs]

Cold Fusion is the way to go. You can use ODBC to access just about any type of database, xBase, Access, Paradox. It is relatively inexpensive, easy to install/configure and if you are already used to xBase or Access programming, you can pick it up quick.