Is anybody out there using this combination... Witango 5.5 on Linux unixODBC (some ODBC driver for Oracle) Oracle
Most of our stuff uses mySQL, but for one site, we're connecting to the clients system for a few queries. That system is Oracle based. Currently we're using JDBC drivers provided by oracle. But I want to switch to ODBC. Witango's JDBC code is not as robust as it's ODBC code, for example, if a db connection is severed, by the server for some reason, witango's ODBC pool will realize that, and drop the connection and create a new one if needed. On the JDBC side, it will continue to try to use that connection, causing errors. This goes on untill you do a Witango restart. Anyway, since I do very little with Oracle, not that familiar with the tools provided by oracle, or 3rd party tools that i might need. I get the impression wading through oracle's site, that they don't have an ODBC driver for Linux, (windows only) and I've found two vendors for ODBC Oracle Linux drivers from easysoft.com and datadirect.com I'm trying to get the eval version of the datadirect driver working right now, and I'm getting a vague connection error, so I figured it wouldn't hurt to ask if anybody out there has a combination similar to this working. The bigger thing going on is that I want to encrypt the DB connection, because currently we're going through a VPN, but I'd like to drop the VPN from the equation and go with a simpler SSL or SSH tunnel type setup. I just figured switching to ODBC at the same time would be a good thing to do at the same time (due to the problems i mentioned above) /John ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
