Re: dg4odbc on Linux?
Date: Wed, 21 Oct 2009 15:16:40 +0000 (UTC)
Message-ID: <pan.2009.10.21.15.10.19_at_email.here.invalid>
On Wed, 21 Oct 2009 03:30:36 +0000, Mladen Gogala wrote:
> Did anybody succeed in configuring it to connect to a foreign data
> source on Red Hat Linux? If yes, what was the version? Oracle is
> shipping an ODBC driver that is incompatible with the driver manager
> delivered by Red Hat since the version 10.2.0.4. Googling yields
> hundreds of results and yet nothing is done. Does anybody know if that
> is a political decision? Open, yes, but not in such a way that people
> could actually use it? I opened my 2nd SR and still no resolution. I am
> starting to believe that ODBC gateway for anything other than Windows is
> just a marketing ploy, a bad one at that. In other words, I don't think
> that Oracle is interested in enabling people to use MySQL or PostgreSQL
> in tandem with Oracle. It only pisses me off that they don't tell me
> that and waste my time.
Well, it seems that I was wrong on both counts:
It does work, the problem was in the Unicode setting that needs to be disabled in the initDG4ODBC.ora, and it is available for standalone download. One needs to select 11g database and go to the gateways, instead of the entire database.
-- http://mgogala.freehostia.comReceived on Wed Oct 21 2009 - 10:16:40 CDT