Hello all,

I've been doing some research but haven't come up with some solid
answers and I'm hoping you can lend a few minutes to help me out.

I'm trying to connect to an Oracle 8.9 database.

There are a couple ways we're exploring:

1. Connect to Oracle directly via ODBC

2. Create a "link" between SQL Server 2k and Oracle 8.9

A couple questions:

For option #1 above, will Oracle ODBC Rdb Release 3.2.0.0 connect to
Oracle 8.9?

For option #2 above, what are our options? How do we "link" these
databases together?

Any advice would be much appreciated!

Thanks,
Andy

"Andy" <andymilk (AT) gmail (DOT) com> wrote


In SQLServer you create a 'Linked Server'. You can do that easily in MS SQL
Management Studio tool.
I'm not familiar with RDB, but in 'normal' Oracle you can use Heterogeneous
Services to link from Oracle to non-Oracle systems.

--
Terry Dykstra

"Andy" <andymilk (AT) gmail (DOT) com> wrote


In SQLServer you create a 'Linked Server'. You can do that easily in MS SQL
Management Studio tool.
I'm not familiar with RDB, but in 'normal' Oracle you can use Heterogeneous
Services to link from Oracle to non-Oracle systems.

--
Terry Dykstra

"Andy" <andymilk (AT) gmail (DOT) com> wrote


In SQLServer you create a 'Linked Server'. You can do that easily in MS SQL
Management Studio tool.
I'm not familiar with RDB, but in 'normal' Oracle you can use Heterogeneous
Services to link from Oracle to non-Oracle systems.

--
Terry Dykstra

"Andy" <andymilk (AT) gmail (DOT) com> wrote


In SQLServer you create a 'Linked Server'. You can do that easily in MS SQL
Management Studio tool.
I'm not familiar with RDB, but in 'normal' Oracle you can use Heterogeneous
Services to link from Oracle to non-Oracle systems.

--
Terry Dykstra

Andy (andymilk (AT) gmail (DOT) com) wrote:


: 1. Connect to Oracle directly via ODBC

: For option #1 above, will Oracle ODBC Rdb Release 3.2.0.0 connect to
: Oracle 8.9?

I wouldn't think so, the Rdb driver connects to RDB.

RDB was a competing product from Digital that runs on VMS (VAX and Alpha).
Oracle bought it when Digital went bankrupt, so it is an Oracle database
product now (suported and everything), but it's not at all the same thing
as _the_ Oracle database (6, 7, 8i, 9i, 10G ... etc etc).

Andy (andymilk (AT) gmail (DOT) com) wrote:


: 1. Connect to Oracle directly via ODBC

: For option #1 above, will Oracle ODBC Rdb Release 3.2.0.0 connect to
: Oracle 8.9?

I wouldn't think so, the Rdb driver connects to RDB.

RDB was a competing product from Digital that runs on VMS (VAX and Alpha).
Oracle bought it when Digital went bankrupt, so it is an Oracle database
product now (suported and everything), but it's not at all the same thing
as _the_ Oracle database (6, 7, 8i, 9i, 10G ... etc etc).

Andy (andymilk (AT) gmail (DOT) com) wrote:


: 1. Connect to Oracle directly via ODBC

: For option #1 above, will Oracle ODBC Rdb Release 3.2.0.0 connect to
: Oracle 8.9?

I wouldn't think so, the Rdb driver connects to RDB.

RDB was a competing product from Digital that runs on VMS (VAX and Alpha).
Oracle bought it when Digital went bankrupt, so it is an Oracle database
product now (suported and everything), but it's not at all the same thing
as _the_ Oracle database (6, 7, 8i, 9i, 10G ... etc etc).

Andy (andymilk (AT) gmail (DOT) com) wrote:


: 1. Connect to Oracle directly via ODBC

: For option #1 above, will Oracle ODBC Rdb Release 3.2.0.0 connect to
: Oracle 8.9?

I wouldn't think so, the Rdb driver connects to RDB.

RDB was a competing product from Digital that runs on VMS (VAX and Alpha).
Oracle bought it when Digital went bankrupt, so it is an Oracle database
product now (suported and everything), but it's not at all the same thing
as _the_ Oracle database (6, 7, 8i, 9i, 10G ... etc etc).

Hi Terry,

Thanks for the help.

I won't have any control of the Oracle database, so I basically need
to use ODBC or SQL Server to connect to it. Once SQL server is
"linked", can I talk to the ODBC connection that is connected to my
SQL Server, and query data from the Oracle linked server?

I need to pull data from Oracle, insert it into SQL Server tables, and
then access that data with ColdFusion. Can I write queries that
execute on a schedule to pull data from Oracle and insert into SQL
Server tables?

Thanks,
Andy