asp & oracle

i'm looking for expertise for asp and oracle...i have problems with it...if possible, xplain from beginning...from installing oracle, whats needed to use oracle n asp, n how to configure it

ultra78

Originally posted by ridrez at 27-7-2006 03:07 PM
i'm looking for expertise for asp and oracle...i have problems with it...if possible, xplain from beginning...from installing oracle, whats needed to use oracle n asp, n how to configure it

i am assuming you have installed oracle on a server.

1) On the web server,you need to install Oracle client.
2)Use Oracle Net Manager to add the Oracle Server (Sounds like DSN setting in Windows).You need the Oracle server's server name/IP address and Service name (which is defined when setting up the oracle server).

Under Service Naming Folder,click the Add/+
Net Service Name is what you want the connection to be named.It is local to that PC and does not need to match with oracle service name on the server.

Then choose TCP/IP or whatever communication protocol and click next.
Hostname is the Oracle server server name or IP Address.

Then enter Service Name.This is service name defined on the Oracle Server.I am assuming you're using Oracle8i,Oracle9i or Oracle10g.sid is for old oracle versions.

Click next and finish

After finishing,don't forget to 'File->Save network configuration'.

Configuration on the oracle part is done.you can access the database server using SQL Plus.
But you cannot access it from ASP yet.You need to configure the ODBC.

3)From windows,go to control panel->Administrative Tools->Data Sources(ODBC).Select System DSN->Add
Select 'Microsoft ODBC for Oracle'

then you will be asked

Data Source Name = your local DSN name
Description = not compulsary
userame = not compulsary
Server = is the local Net Service Name defined earlier in Oracle Net Manager.

After you have finished,then you can access the database through odbc.you can program your asp to access the defined dsn for oracle.

sounds complicated?Nahh...

Since you're developing in asp/microsoft,then i'm willing to give you the step-by-step guide.But if you're linux user,then i would say RTFM.Hahaha...just kidding..

ultra78

I'm not really an oracle expert,just a developer.We need expert guide on 'installing' Oracle database.Oracle database is actually easy to install,but you need to properly plan your database first.And this is related to the database configuration (undo,tablespaces,partitioning,etc,etc).The rule of thumb is not to part your databases/table/indexes in system tablespace.Like I said earlier,proper planning is important.

LanoG

It is always a good start with reading all documentation included in the Oracle's website. All updated features included and there was an active Oracle's forum.