On 12/4/07, Joaquin Herrero  wrote:

quoted text
> Hi,

>

> I'm using "freetds" from my OpenBSD machine to connect to a MS SQL Server

> and works like a charm. Now I need to access to a Oracle  server but it

> seems that the TDS protocol is not supported by Oracle databases, they use

> their own protocol named TNS and there is no "freetns" available.

>

> I investigated if I could use ODBC, but it seems (afaik) that ODBC needs a

> specific driver for each database and I do not know if there is such driver

> for OpenBSD.

>

> Perhaps someone know...

> a) if with freetds it is possible to connect to Oracle (perhaps activating

> some "tds listener" in the database)

> b) if ODBC is usable in OpenBSD to talk to Oracle.

>

> I'm using OpenBSD in a sparc machine at the moment (Sun Netra T1), but I can

> use a x86 machine as well.

>

> Any comments appreciated.

Some quick googling shows

http://www.bsdforums.org/forums/archive/index.php/t-23706.html

http://archives.neohapsis.com/archives/openbsd/2001-07/2129.html

It looks like there's no BSD-specific oracle client, but that you may

be able to use a binary blob linux client under linux emulation to

make it work (but that it'll be kind of lame).
You might be able to run another database as a wrapper around the

oracle one? e.g. see

http://www.sqlmag.com/Article/ArticleID/22264/sql_server_22264.html ?
-Nick