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.

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.
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