Connect to Oracle Database using ASP without changes to Server

Hello,

I want to connect to an Oracle Database from my Classic ASP page, however I can't install drivers or make any changes on the web server. Is this still possible? Can you provide a short connection example?

Thanks!
intoxicated_curveballAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
It's been many many years since I did anything with classic ASP but back in the day we used Oracle Objects for OLE (OO4O).

The easiest and smallest possible Oracle client is the Instant Client:
http://www.oracle.com/technetwork/topics/winsoft-085727.html

There is no 'install' per say.  Normally you just unzip and run.


If you can use the OCI interface all you need is the basic package:
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications


If you want to use OO4O there is another package to download:
Instant Client Package - ODAC: Includes ODP.NET, Oracle Services for MTS, Oracle Providers for ASP.NET, Oracle Provider for OLE DB, and OO4O with Oracle Instant Client

There is an install.bat file you need to run for this one.
0
 
slightwv (䄆 Netminder) Commented:
The only way I know of to connect to an Oracle database without a driver installed is JDBC Thin.

My classic ASP memories are really old but I don't remember a way to connect using JDBC.
0
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Oracle needs a driver to be installed as do most other databases.  http://www.oracle.com/technetwork/database/features/oci/index.html
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
intoxicated_curveballAuthor Commented:
Hi can you provide a site for JDBC Thin download and install instructions?
0
 
slightwv (䄆 Netminder) Commented:
There is no download.  A download sort of implies something to install.

Google around for jdbc thin connections.  I don't think it will work with VBScript but you never know.
0
 
intoxicated_curveballAuthor Commented:
This is not helping me... I have no idea where to start
0
 
slightwv (䄆 Netminder) Commented:
The odds are there is no answer to your question. I gave you the only possible clientless connection the I know of.

I also don't think that it will work with classic ASP.

Jdbc thin is a java connection string.  There isn't anything else to it.  It either connects to the database, or it doesn't.
0
 
intoxicated_curveballAuthor Commented:
OK, thanks. I wonder someone can offer the simplest solution to this in, i.e. what method would require the least web server changes?
0
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Even Microsoft Access requires a driver but that is probably already installed on a Windows server.  The OCI driver is the only way Oracle lists to connect to an Oracle database server.  I gave you the link above.
0
 
slightwv (䄆 Netminder) Commented:
What additional information would you have required before giving an "A" grade?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.