• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1257
  • Last Modified:

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!
0
intoxicated_curveball
Asked:
intoxicated_curveball
  • 5
  • 3
  • 2
3 Solutions
 
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 BaldwinFixer 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
 
intoxicated_curveballAuthor Commented:
Hi can you provide a site for JDBC Thin download and install instructions?
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
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 BaldwinFixer 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:
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:
What additional information would you have required before giving an "A" grade?
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now