On 12/4/07, Joaquin Herrero <[EMAIL PROTECTED]> wrote: > 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
