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. regards > -----Urspr|ngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag > von Joaquin Herrero > Gesendet: Dienstag, 4. Dezember 2007 23:09 > An: misc@openbsd.org > Betreff: Access to a remote Oracle database > > > 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
