Henning Thielemann wrote:
On Sat, 21 Jun 2008, Lanny Ripple wrote:
I had luck with this the other day using Database.HDBC.ODBC. For Ubuntu's Hardy I found that Oracle's 10.2.0.3 worked best. (10.2.0.4 and 11 seemed to have problems for me at least.)
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linu...
Grab the basic (not basic-lite), odbc, and sqlplus (to test) zips. The odbc_update_ini.sh should be run from inside the instantclient_10_2 directory as root
sudo /bin/sh odbc_update_ini.sh /
(assuming a standard unixODBC install.) You'll also need a tnsnames.ora file to describe your connection(s) to the DB(s). You'll also need to define some environment variables to run against all this. I use a small script:
#!/bin/sh oracle_home=/opt/lib/oracle/instantclient_10_2 export TNS_ADMIN=$oracle_home export LD_LIBRARY_PATH=$oracle_home [ $# = 0 ] && exit 1 exec "$@"
Thank you for the detailed hints! However, I tried a lot of this and that, but without a possibility to track down what went wrong, the ways to fix the probable problems are unbounded. Finally I get 'Driver's SQLAllocHandle on SQL_HANDLE_HENV failed' when I start 'isql' and that's where systematic error analysis stops and wild guessing starts. Since OCI and sqlplus work on my machine, I'll try to follow this way.
There are also Database.HSQL Database.HSQL.Oracle It works through OCI as well. It's not clear (to me at least) if it is/will be supported. It has back-ends for multiple DBs (is Takusen only for Oracle?) It doesn't take the typeful approach, that Takusen takes (may be a plus in some situations)