Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Zero Client front end to Oracle
Hi Rich,
to the best of my knowledge, if you want to access an Oracle database without client, you'll need to go through a web interface to a web server running Apache with mod_plsql fitted which does have Oracle client and can therefore talk to the database.
On the other hand, 9i has something called iSQLPlus which is a 3 tier system - again, browser based. The client PCs only need a browser, the middle tier is the HTTP server and from there to the database server. I've seen it demonstrated, but whether you can call it from a VB script and get results back again - I have no idea. I also believe that it has a number of security problems.
I think you are bolloxed if you can't install client on the users machines.
HTH
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: richmarin_at_earthlink.net (Rich) [mailto:richmarin_at_earthlink.net]
Posted At: Wednesday, June 11, 2003 3:34 PM
Posted To: server
Conversation: Zero Client front end to Oracle
Subject: Zero Client front end to Oracle
I need to create a front end to an Oracle database. The company I work for requires that I use VB scripts. And they do not want anything installed on the end user's PC.
The front end must be able to allow users to interactively ( thru pull down menus, combo boxes etc . . . ) create SQL statements. Then the SQL statements will query the back end Oracle tables. The data is to be retrieved and sent the Excel spreadsheets on the end users desktop.
Can the above be done with Oracle and VB scripts on an intranet? Received on Wed Jun 11 2003 - 09:54:31 CDT