Re: DSN Less Connection To Oracle Database

On Fri, 12 Sep 2008 05:36:41 GMT, Louis <t051315@xxxxxxxxxxx> 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.

--
Sybrand Bakker
Senior Oracle DBA
.

Relevant Pages

  • Re: Oracle Client
    ... connect to your database using SQL*Plus. ... This will display the version of the Oracle Server that you've connected to. ... Yes, the Oracle 9iR2 Client can be downloaded, and it will connect to your ... I am having problems with this driver, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DSN Less Connection To Oracle Database
    ... The jdbc thin driver doesn't need a client. ... Which client would depend on Oracle version, ...
    (comp.databases.oracle.misc)
  • Re: ASP and Oracle 9i
    ... Try installing the Oracle Net 8 client on the web-server. ... driver was never updated for Oracle 9. ... > problems connecting to the database. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Oracle Client
    ... supports Oracle9i Release 2 or higher client. ... Oracle provider has some additional features. ... I am having problems with this driver, ... > I could not find just a simple .net driver download on ORacle site, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SBS 2003 - SBS 2008 migration issues
    ... DHCP cannot work properly with the hyper-v role, and probably DNS, neither will the configuration wizards. ... clients losing the ability to use it after removing trend client, reseting winsock / removing network components / reinstalling teh client don't bring it back. ... When I add the 32 bit driver to the printer it simply tells me it's not a suitable driver, and to try adding the driver from a 32 bit client. ... If I install hyperV on the SBS 2008 will it run a win2k3 server? ...
    (microsoft.public.windows.server.sbs)