| Author |
 Topic Search  Topic Options
|
vladanr 
Newbie
Joined: 07 September 2003
Location: Yugoslavia
Status: Offline
Points: 7
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: ASP with Oracle database
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 
|
 |
zMaestro
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 September 2003 at 11:52am |
I am in a very similar situation... waiting with you for the help 
|
|
Tegwin
Senior Member
Joined: 03 September 2003
Location: United Kingdom
Status: Offline
Points: 430
|
Post Options
Thanks(0)
Quote Reply
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
HTH
|
|
vladanr
Newbie
Joined: 07 September 2003
Location: Yugoslavia
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
zaboss
Senior Member
Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
pivan
Newbie
Joined: 08 September 2003
Location: Slovenia
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
zMaestro
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 September 2003 at 2:50am |
 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
|
|
vladanr
Newbie
Joined: 07 September 2003
Location: Yugoslavia
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
