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/linuxsoft.html
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)
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe