Suggestions on connecting to Ora via ODBC?

From: Ted Haasl-Martinez <tedm_at_vcd.hp.com>
Date: Tue, 23 Mar 1999 12:11:20 -0800
Message-ID: <36F7F567.6289D9E5_at_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 - 21:11:20 CET