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.
Oops. And the sdk zip. > 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 "$@" > > Best of luck, > -ljr > > > Steve Lihn wrote: >> You may want to check this out. >> >> http://www.orafaq.com/wiki/ODBC_FAQ#Where_can_one_get_ODBC_drivers_for_Oracle_and_Rdb.3F >> >> As Oracle is a commercial company who is not interested in open source >> historically, it is little chance that you will get robust software >> for free -- from someone with many years of Oracle DBA experience :-) >> >> >> On 6/19/08, Henning Thielemann <[EMAIL PROTECTED]> wrote: >>> Is there a way of accessing a remote Oracle database by one of the common >>> Haskell database interfaces (HaskellDB, Takusen, etc.) ? I tried to get >>> unixODBC and Oracle's Instant Client running on a Linux machine, but I'm >>> trapped in the notorious error: >>> >>> $ isql USER -v >>> [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV >>> failed >>> [ISQL]ERROR: Could not SQLConnect >>> >>> This error message is discussed in various web forums, but there seems to be >>> no systematic way to track down the problem. So I wonder whether there is >>> another way to access the Oracle data base from Haskell. >>> _______________________________________________ >>> Haskell-Cafe mailing list >>> Haskell-Cafe@haskell.org >>> http://www.haskell.org/mailman/listinfo/haskell-cafe >>> >> _______________________________________________ >> Haskell-Cafe mailing list >> Haskell-Cafe@haskell.org >> http://www.haskell.org/mailman/listinfo/haskell-cafe > _______________________________________________ > Haskell-Cafe mailing list > Haskell-Cafe@haskell.org > http://www.haskell.org/mailman/listinfo/haskell-cafe _______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe