Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Suggestions on connecting to Ora via ODBC?

Suggestions on connecting to Ora via ODBC?

From: Ted Haasl-Martinez <tedm_at_vcd.hp.com>
Date: Tue, 23 Mar 1999 11:20:25 -0800
Message-ID: <36F7E979.DC9D1F5F@vcd.hp.com>


What solutions have you used (are using) to connect to an Oracle   server(7.x-8. on HP-UX 10.2), from a Unix client?

  I'd like to have my application 'talk/connect' via generic ODBC   to the Oracle server, and would REALLY like not to have another   3rd party piece(ODBC Broker/manager) on the DB server.

  I'd also like to keep this a two tier solution.   Also, the application was developed in perl cgi.

  From what I've seen so far, the options come down to:

  1. use an ODBC unix client driver that talks to the Oracle middleware(sqlNET); Any Suggestions? Intersolve/Merant, etc...?
  2. use PERL:DBI::Oracle (but does this really talk to Oracle??/SQLNET?? or is there another component that will be necessary on the server (other than perl and it's libraries??).
  3. use Oracle's native ODBC drivers...(Do they have a 32bit Unix client driver?)
  4. use an ODBC package that has a client AND a server component (least desirable).

 Any help is greatly appreciated...

 TIA! -tedm
tedm_at_vcd.hp.com Received on Tue Mar 23 1999 - 13:20:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US