| |
 |
|
| Computers Forum Index » Computer - Databases - Oracle (Server) » dg4odbc on Linux?... |
|
Page 1 of 1 |
|
| Author |
Message |
| Mladen Gogala... |
 Posted: Wed Oct 21, 2009 3:30 am |
|
|
|
Guest
|
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.
--
http://mgogala.freehostia.com |
|
|
| Back to top |
|
|
|
| Mladen Gogala... |
| Posted: Wed Oct 21, 2009 4:18 am |
|
|
|
Guest
|
On Wed, 21 Oct 2009 14:50:25 +1100, Geoff Muldoon wrote:
Quote: 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. First, there is no
such product available for download. One has to download the whole
caboodle. Second, when one does download the whole thing, it doesn't
work. I opened a SR, uploaded files and the Oracle analyst responded that
he cannot open TGZ files and asked me to re-send the whole thing. That
tells me something about the resources that Oracle Corp. is putting into
that product, even if I hadn't noticed that they're shipping incompatible
software for almost 2 years now. At this point, I am close to wiping it
all out and downloading the good, old Oracle 10.2.0.3 which I know to
work. Basically, ODBC gateway is just a marketing feature, it doesn't
really work.
--
http://mgogala.freehostia.com |
|
|
| Back to top |
|
|
|
| Geoff Muldoon... |
| Posted: Wed Oct 21, 2009 5:15 am |
|
|
|
Guest
|
In article <hblv8s$r37$1 at (no spam) solani.org>, Mladen Gogala says...
Quote: 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.
Have managed to get Oracle 10.2 on RHEL4 to talk to MS-MSQL using uxixODBC
and FreeTDS.
GM |
|
|
| Back to top |
|
|
|
| yossarian... |
| Posted: Wed Oct 21, 2009 11:21 am |
|
|
|
Guest
|
Mladen Gogala wrote:
Quote: In
oracle11, they have this shiny new product which was supposed to be a
standalone product, and which would do the same thing.
So hsodbc is not shipped anymore with 11g? What are the claimed benefits
of this new product over hsodbc?
Y. |
|
|
| Back to top |
|
|
|
| Mladen Gogala... |
| Posted: Wed Oct 21, 2009 11:48 am |
|
|
|
Guest
|
On Wed, 21 Oct 2009 12:13:23 +0100, Palooka wrote:
Quote: On 21/10/09 05:18, Mladen Gogala wrote:
the Oracle analyst responded that
he cannot open TGZ files
WTF?
Palooka
My reaction, exactly.
--
http://mgogala.freehostia.com |
|
|
| Back to top |
|
|
|
| Mark D Powell... |
| Posted: Wed Oct 21, 2009 2:58 pm |
|
|
|
Guest
|
On Oct 21, 3:21 am, yossarian <yossaria... at (no spam) operamail.com> wrote:
Quote: Mladen Gogala wrote:
In
oracle11, they have this shiny new product which was supposed to be a
standalone product, and which would do the same thing.
So hsodbc is not shipped anymore with 11g? What are the claimed benefits
of this new product over hsodbc?
Y.
HSODBC is still present in 11g. 11g also supports the Open Gateway
interface which dg4odbc is part of.
As far as getting dg4odbc installed and working I do not have a clue
but I am pretty sure it is needed for the HSODBC interface as well as
the Gateway product.
There is a separate manual on the feature: OracleŽ Database
Heterogeneous Connectivity Administrator's Guide
10g Release 2 (10.2) Part Number B14232-01. One possible issue on 64
bit systems is that Oracle specifies that the ODBC driver must be 32
bit.
HTH -- Mark D Powell -- |
|
|
| Back to top |
|
|
|
| Palooka... |
| Posted: Wed Oct 21, 2009 3:13 pm |
|
|
|
Guest
|
On 21/10/09 05:18, Mladen Gogala wrote:
Quote: the Oracle analyst responded that
he cannot open TGZ files
WTF?
Palooka |
|
|
| Back to top |
|
|
|
| Mladen Gogala... |
| Posted: Wed Oct 21, 2009 3:16 pm |
|
|
|
Guest
|
On Wed, 21 Oct 2009 03:30:36 +0000, Mladen Gogala wrote:
Quote: 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 |
|
|
| Back to top |
|
|
|
| Geoff Muldoon... |
| Posted: Thu Oct 22, 2009 1:49 am |
|
|
|
Guest
|
Mladen Gogala says...
Quote: 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 |
|
|
| Back to top |
|
|
|
| Mladen Gogala... |
| Posted: Thu Oct 22, 2009 2:53 am |
|
|
|
Guest
|
On Thu, 22 Oct 2009 08:49:56 +1100, Geoff Muldoon wrote:
Quote: 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 |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Mon Nov 23, 2009 9:08 pm
|
|