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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to setup ODBC on Solaris ??

Re: How to setup ODBC on Solaris ??

From: Tom Fosdick <tom_at_easysoft.com>
Date: 2000/06/16
Message-ID: <8icruq$k82$1@alsvider.easysoft.com>#1/1

In comp.databases.oracle.misc Alexandros Kotsiras,  NYC <alexandros_k_at_prodigy.net> wrote:
: I want to setup ODBC driver and DSN for Oracle8.1.5 on a Solaris2.6
: machine.
: I have done that several times on Windows platform where it is pretty
: simple but on Solaris i don't know how start. How do i obtain the driver
: for Solaris ?

Oracle themselves don't produce an ODBC driver for Solaris. There are several third party organisations however who produce software which could help.

: Do i need to install some part of Oracle client ?

Depends on your chosen solution :- there are two basic ways you could connect.

  1. Use a third party ODBC Oracle driver on the Solaris machine. In this case you will need at least part of the Oracle client (Net8) on the Solaris box.
  2. Use an odbc-odbc bridge. You won't need the Oracle client, but this adds an extra layer into the model so could be slower (and more expensive).

As a third solution, you may like to consider reimplementing your applications to use the OCI API rather than ODBC (assuming you have the source code for them).

: Then
: how do i create a DSN name which i can use from a DB client application
: ? ?
: Are there any sites that have resources ? ?

Free software and information...

http://www.unixODBC.org
http://users.ids.net/~bjepson/freeODBC/
http://www.iodbc.org

Commercial solutions from...

http://www.easysoft.com
http://www.merant.com
http://www.openlinksw.com

...and probably many more
-- 
 Tom Fosdick
 tom_at_easysoft.com
 http://www.easysoft.org
Received on Fri Jun 16 2000 - 00:00:00 CDT

Original text of this message

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