* Joaquin Herrero <[EMAIL PROTECTED]> [071204 17:27]: > 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 >
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
