From: Mladen Gogala on
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.com
From: Geoff Muldoon on
Mladen Gogala says...
> On Wed, 21 Oct 2009 14:50:25 +1100, Geoff Muldoon wrote:
>
> > Have managed to get Oracle 10.2 on RHEL4 to talk to MS-MSQL using
> > uxixODBC and FreeTDS.
>
> Me too. That was 10.2.0.3. That, however, was not the question. In
> oracle11, they have this shiny new product which was supposed to be a
> standalone product, and which would do the same thing.

Thanks for the heads up, haven't had time to explore 11g yet and didn't
know about that. Glad to see from your other posting that you have
seemingly have got it sorted.

GM
From: Mladen Gogala on
On Thu, 22 Oct 2009 08:49:56 +1100, Geoff Muldoon wrote:

> Mladen Gogala says...
>> On Wed, 21 Oct 2009 14:50:25 +1100, Geoff Muldoon wrote:
>>
>> > Have managed to get Oracle 10.2 on RHEL4 to talk to MS-MSQL using
>> > uxixODBC and FreeTDS.
>>
>> Me too. That was 10.2.0.3. That, however, was not the question. In
>> oracle11, they have this shiny new product which was supposed to be a
>> standalone product, and which would do the same thing.
>
> Thanks for the heads up, haven't had time to explore 11g yet and didn't
> know about that. Glad to see from your other posting that you have
> seemingly have got it sorted.
>
> GM

So far, I successfully moved an exceedingly complex schema containing 4
tables. One describes employees of a small company and has 14 rows, while
the other one is describing departments of the same company, having 4
rows...



--
http://mgogala.freehostia.com
First  |  Prev  | 
Pages: 1 2
Prev: Oracle 11gR1 PS/PS login error...
Next: RMAN-06025