Print Page | Close Window

ASP with Oracle database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5587
Printed Date: 30 March 2026 at 9:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: ASP with Oracle database
Posted By: vladanr
Subject: ASP with Oracle database
Date Posted: 07 September 2003 at 11:38am

I have created a web site in ASP using Access database, but now I have to add a page that displays some data from an Oracle database. That database is too big to be handled by Access.

There the problems begin. On the machine with Oracle (Windows 2000 advanced server) there is installed Apache web server which seems to be preventing me from running ASP. Although I create a virtual directory, internet explorer displays a page telling me that it does not exist.

Secondly, I have never used an oracle database with ASP, and I don’t know if I should transfer all the data from Access database to Oracle and use only that. Also I don’t know are there any differences in connecting to an Oracle database, compared to an Access database.

Any advice would be appreciated




Replies:
Posted By: zMaestro
Date Posted: 07 September 2003 at 11:52am
I am in a very similar situation... waiting with you for the help


Posted By: Tegwin
Date Posted: 07 September 2003 at 3:43pm

Cant really help on the Oracle side, but you can either stop the apache service (from the services) It may be under all the Oracle Services - Something like Oracle Web Server, or alternatively you can change the port on IIS and then access it as http://webserver:portnum - http://webserver:portnum

HTH

 



Posted By: vladanr
Date Posted: 08 September 2003 at 1:14am

I have tried that already, Apache is Oracle’s web server, but even when I stop it my virtual directory isn’t working.

 

What is your “situation” zMaestro?



Posted By: zaboss
Date Posted: 08 September 2003 at 1:46am

Vladanr, turn off the friendly error messages in your browser and tell us what is the error. Also, do check:

1. If you have installed and running the right connection driver
2. You have the corect connection statements in your asp code
3. You have no erors in your code

My advice is to stick to a more "asp friendly" db, like SQL Server... May be Oracle one the most powerful db management systems, but the driver that connects it to asp is a little behind and you have to hard code yourself a lot in order to have the same performance as with SQL server.



-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web


Posted By: pivan
Date Posted: 08 September 2003 at 2:13am
[09:50] Boky: nije mi bas jasno, sta ga muci
[09:50] Boky: mozes ti da mi objasnis?
[09:50] Boky: koliko mi je jasno:
[09:51] Boky: 1. ima IIS & ASP projekat u kome cita podatke iz Accessa
[09:51] Boky: 2. Sad oce nesto sa oraclom, ali ne moze...?
[09:52] Istvan: pa mislim da je napravio varijantu sa accessom (testnu)
[09:53] Istvan: i onda provalio da ima previse podataka
[09:53] Istvan: i presaltao se na oracle
[09:53] Istvan: i sada se pati da ga pokrene
[09:53] Istvan: asp + oracle
[09:53] Boky: znaci, ako mi je skroz jasno:
[09:53] Boky: na istom serveru ima IIS (sa ASPjem) i Oracle DB
[09:54] Boky: i sad oce, da rade zajedno, ali mu oracle ugurava Apache?
[09:54] Istvan: Windows 2000 advanced server
[09:54] Istvan: da
[09:54] Boky: aha.
[09:54] Boky: ovako:
[09:55] Boky: za dostup do Oracle iz ASPja, treba da upotrebis Microsoftov Oracle OLE DB drajver
[09:55] Boky: drajver koristi Oracle biblioteku
[09:55] Boky: koja dodje pored server (ili klient) instalacije Oracla (cca. 160MB)
[09:55] Boky: znaci, u ASPju promenis datasource i to bi trebalo da bude to (mada ce morati verovatno da menja i kverije)
[09:55] Boky: druga stvar:
[09:56] Boky: pored oracla dodje jos dosta drugih stvari, izmenju ostalog i Apache web server
[09:56] Boky: (odnosno, kao sto ga oracle zove, Oracle web server)
[09:57] Boky: dosta je, da servis (Control Panel / Services) ugasis (manestis na Disabled)
[09:57] Boky: i Apache i IIS vise nece da se pucaju za port 80
[09:57] Boky: i proradice IIS.


Posted By: zMaestro
Date Posted: 08 September 2003 at 2:50am

Originally posted by vladanr vladanr wrote:

What is your “situation” zMaestro?

"really it is the second part of the question: I have never used an oracle database with ASP, and I don’t know if I should transfer all the data from Access database to Oracle and use only that. Also I don’t know are there any differences in connecting to an Oracle database, compared to an Access database."

a book store has an access database holding books and about 650MB, they were adviced to use ORACLE... and they asked me about.. but I really didn't deal with b4, even I don't knoe how to connect to it
I suggested using SQL



Posted By: vladanr
Date Posted: 08 September 2003 at 6:02am

I'll try to translate what pivan said in his message in serbian:

When you install Oracle (about 160MB) you have to use Microsofts Oracle OLE DB driver and connect to oracle db as you do to access's.

But the problem is Oracle's web server which conflicts IIS and you have to disable it from Control Panel / Services in order for IIS to work.

I'll try it and let you know what heppens.




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net