Hi,

Can any body explain me on how to obtain connectivity between oracle
and progress database. The progress database already exists and i need
to use it in oracle. And hence need to obtain a connection between
Oracle and Progress database.

shivanghurra@gmail.com wrote:

> Can any body explain me on how to obtain connectivity between oracle
> and progress database. The progress database already exists and i need
> to use it in oracle. And hence need to obtain a connection between
> Oracle and Progress database.

If Progress database supply an ODBC driver, you can use Heterogeneus
Services.

HS is documented on http://tahiti.oracle.com

If your Oracle platform is Linux, you can find useful hints on
http://www.gesinet.it/oracle/genericconnectivity.html

Kind regards,

--
Cris Carampa (spamto:cris119@operamail.com)

se avete preso per buone le verità della televisione
anche se allora vi siete assolti siete lo stesso coinvolti

Hi cris,
could you please provide me with some example or code that code be used
for connectivity. Or if there is any other way please let me know. As i
am new to progress database.

And from where can i find out that the progress database supplies an
ODBC driver.



Cris Carampa wrote:

> shivanghurra@gmail.com wrote:
>
> > Can any body explain me on how to obtain connectivity between oracle
> > and progress database. The progress database already exists and i need
> > to use it in oracle. And hence need to obtain a connection between
> > Oracle and Progress database.
>
> If Progress database supply an ODBC driver, you can use Heterogeneus
> Services.
>
> HS is documented on http://tahiti.oracle.com
>
> If your Oracle platform is Linux, you can find useful hints on
> http://www.gesinet.it/oracle/genericconnectivity.html
>
> Kind regards,
>
> --
> Cris Carampa (spamto:cris119@operamail.com)
>
> se avete preso per buone le verità della televisione
> anche se allora vi siete assolti siete lo stesso coinvolti

shivanghurra@gmail.com wrote:

> could you please provide me with some example or code that code be used
> for connectivity. Or if there is any other way please let me know. As i
> am new to progress database.
>
> And from where can i find out that the progress database supplies an
> ODBC driver.

I'm sorry, but I never heard of a database called "Progress" until this
morning My only proposition was: "*If* Progress database supplies an
ODBC driver, *then* you should be able to use Oracle Heterogeneus
Services in order to access Progress table from Oracle environment". If
you have specific question about Progress, you have to post them in a
Progress forum or mailing list, since this is an Usenet newsgroup called
"comp.databases.*oracle*.server".

Good luck. Kind regards,

--
Cris Carampa (spamto:cris119@operamail.com)

se avete preso per buone le verità della televisione
anche se allora vi siete assolti siete lo stesso coinvolti

Ciao Cris,

Il tuo suggerimento mi interessa molto:

secondo te, quindi, è possibile configurare Oracle per andare su altri
databases utilizzando i Drivers ODBC,
utilizzando Heterogeneus Services.
Come funziona esattamente?
Forse che io mi connetto ad oracle, faccio delle query ed il server stesso
le gira al database originario?
Una sorta di DBLink utilizzando gli ODBC?

Paolo

"Cris Carampa" <cris119@operamail.com> ha scritto nel messaggio
news:43ce2475$0$337$5fc30a8@news.tiscali.it...
shivanghurra@gmail.com wrote:

> could you please provide me with some example or code that code be used
> for connectivity. Or if there is any other way please let me know. As i
> am new to progress database.
>
> And from where can i find out that the progress database supplies an
> ODBC driver.

I'm sorry, but I never heard of a database called "Progress" until this
morning My only proposition was: "*If* Progress database supplies an
ODBC driver, *then* you should be able to use Oracle Heterogeneus
Services in order to access Progress table from Oracle environment". If
you have specific question about Progress, you have to post them in a
Progress forum or mailing list, since this is an Usenet newsgroup called
"comp.databases.*oracle*.server".

Good luck. Kind regards,

--
Cris Carampa (spamto:cris119@operamail.com)

se avete preso per buone le verità della televisione
anche se allora vi siete assolti siete lo stesso coinvolti

Paolo Imperiale wrote:

> Come funziona esattamente?
> Forse che io mi connetto ad oracle, faccio delle query ed il server stesso
> le gira al database originario?
> Una sorta di DBLink utilizzando gli ODBC?

Paolo,

Your description is correct. Please check out the links I posted for
more info.

(Scusa se ti ho risposto in inglese ma questo è un newsgroup
internazionale )

Ciao,

--
Cris Carampa (spamto:cris119@operamail.com)

se avete preso per buone le verità della televisione
anche se allora vi siete assolti siete lo stesso coinvolti

shivanghurra@gmail.com wrote:
> Hi,
>
> Can any body explain me on how to obtain connectivity between oracle
> and progress database. The progress database already exists and i need
> to use it in oracle. And hence need to obtain a connection between
> Oracle and Progress database.

I'm an Oracle neophyte but have worked with Progress for years.
Progress does provide ODBC connectivity, if you start an ODBC server
against the database properly. Progress also sells an Oracle Data
Server so you can run Progress 4GL against an Oracle database (though
the performance is less then stellar). It all depends on which
direction you're trying to go. Progress is SQL92 compliant.

For details I'd suggest the Progress Email Group at www.peg.com. You
can search the existing forums and join the DataServers list serve to
ask the Progress folks who are doing it.

Letha Tawney
FEI Company