ASP to Oracle...without the Oracle client...
Hi there. I work in a university setting, complete with politics and territorial departments. I am authoring some web pages using third party software for the content management (which uses SQL Server); the 3rd party software requires these pages use ASP. However, there is some data I need to pull off of an Oracle Database and integrate with the regular content.
I have just begun to learn about my options for connecting to Oracle from ASP, and they all involve, if I understand correctly, installing the Oracle client software on the web server.
The department that controls the web server (Win 2000 IIS) has balked on installing the client software. They want to keep the machine "clean".
Is there a method for connecting to Oracle from ASP that does not involve installing the Oracle client on the web server? Maybe just a driver? Someone told me that I might be able to have the ASP page call a procedure on SQL server (which is not on the web server) which in turn connects to Oracle, pulls the data, then returns it to the ASP page. Sounds convoluted, but I guess if it works...
The issue is not going away; we are pretty much tied to ASP for our web development and Oracle for our database needs. Can anyone give me some advice on what direction I should take? Do I have any options? (Besides stealing the web server away...)
Thanks in advance...