DSN Less Connection To Oracle Database

#1

I am looking for help in understanding the software/configuration
architecture to connect to an oracle database from a html/javascript web
page.

I have access to an Oracle database, and I want to retrieve data from it
from a web page on a Windows IIS web server. I think the web server
has an ODBC driver for Oracle. That's about all I know for now.

What I want to do is to code the html page and use javascript to call
some kind of server-side script to query the Oracle database.

What do I need to make this happen? I have a sample of an ASP script,
but so far I can't make it work. What do I need?

- Do I really need an Oracle client installed on the web server?
- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?

Your help is appreciated.
Thank you.

#2

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

Quote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you

need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

Quote:

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It

has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

--
Sybrand Bakker
Senior Oracle DBA

#3

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

Quote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you

need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

Quote:

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It

has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

--
Sybrand Bakker
Senior Oracle DBA

#4

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

Quote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you

need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

Quote:

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It

has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

--
Sybrand Bakker
Senior Oracle DBA

#5

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

Quote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you

need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

Quote:

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It

has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

--
Sybrand Bakker
Senior Oracle DBA

#6

sybrandb (AT) hccnet (DOT) nl wrote:

Quote:

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you
need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It
has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

Thanks for the response. Although I admit that I am still fuzzy on what

I need to solve my problem cause I am not familiar with all the driver
names etc. It will take me some time to look up what they do.

Thank you.

#7

sybrandb (AT) hccnet (DOT) nl wrote:

Quote:

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you
need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It
has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

Thanks for the response. Although I admit that I am still fuzzy on what

I need to solve my problem cause I am not familiar with all the driver
names etc. It will take me some time to look up what they do.

Thank you.

#8

sybrandb (AT) hccnet (DOT) nl wrote:

Quote:

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you
need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It
has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

Thanks for the response. Although I admit that I am still fuzzy on what

I need to solve my problem cause I am not familiar with all the driver
names etc. It will take me some time to look up what they do.

Thank you.

#9

sybrandb (AT) hccnet (DOT) nl wrote:

Quote:

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315 (AT) hotmail (DOT) com> wrote:

- Do I really need an Oracle client installed on the web server
Depends on which interface you plan to use, and which capabilities you
need.
The jdbc thin driver doesn't need a client. All other options, like
the full jdbc driver, and odbc or ole or .net do.
Which client (instant or full) would depend on Oracle version, which
you can't be bothered to mention

- Is "Microsoft ODBC for Oracle" enough for ASP to talk to the Oracle
database?
I would strongly recommend *against* using the Microsoft driver. It
has numerous compatibility issues (ie sql which does work using the
Oracle ODBC driver doesn't work using the Microsoft one), and
Microsoft never ever implemented any Oracle feature beyond 7.3
If you only need to access Oracle I would go OLE or ODP
Apart from that, the ODBC driver definitily needs the Oracle client,
whether you use Microsofts driver or Oracles.

Thanks for the response. Although I admit that I am still fuzzy on what

I need to solve my problem cause I am not familiar with all the driver
names etc. It will take me some time to look up what they do.

Thank you.

#10

On 16 Sep, 01:53, Louis <t051... (AT) hotmail (DOT) com> wrote:

Quote:

Thanks for the response. Although I admit that I am still fuzzy on what
I need to solve my problem cause I am not familiar with all the driver
names etc. It will take me some time to look up what they do.

Thank you.

This may be off some help: http://download.oracle.com/docs/cd/B...o.htm#sthref18

Cheers,

-g