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

Joaquin Herrero

Hi,
afaik all access to oracle databases require oracle client software. only

exception I know of is JDBC ( java database connectivity, which has a thin

client requiring only tcp and the oracle jdbc client, which is pure java.

maybe that is an option.
if not you might connect your ms sql server to the oracle database with Oracle

OLE DB or something like and access oracle via mssql.

Oracle is really tight lipped about their application protocol.  Your

not likely to find a FreeTNS implementation.  If you do, please let me

know.
If your using Perl, you could use DBD::Proxy to get an "Oracle

supported" platform that has the Oracle client installed and then

connect to the database host.  Yes, it's a bit ridiculous, but that's

Oracle...
Jim

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