Passing data from Oracle 7 to 8

[mozgheib]

Hello,

I have an Oracle 7.3.4 instance and an Oracle 8.1.7.4 one. Each sit on its own server. I was wondering how to make data flow from one place to another? The problem that I can see is that I cannot have odbc for Oracle 7 client and 8 client installed on the same machine so if I write a little VB code or even a stored procedure with a dblink on Oracle 7 to flow data to the Oracle 8 how will I access the Oracle 8 since I cannot put Oracle 8 client on 7 for the purpose of reading from 7 and writing to 8.

Thanks.

 

[SantaMufasa]

Mozgheib,

Perhaps I'm missing something, but why can you not have simple, native database links on each end accessing the opposite database? Do you receive errors? If so, please post.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:46 (11Oct04) UTC (aka "GMT" and "Zulu"), 23:46 (10Oct04) Mountain Time)

 

[mozgheib]

to create a dblink you need an oracle host string created. To create a host string you need oracle client installed. So to connect to Oracle 7 I will need oracle 7 client and to 8 I will need oracle 8 client. I do not think oracle 7 and 8 clients can co-exist.

 

[KenCunningham]

A while ago we managed to get Oracle 7 and 8 clients playing nicely together. As far as I recall we had to use the 7 installer to install the 8 client, but if I can find more details I'll post them here.

 

[SantaMufasa]

Mozgheib,

First inaccurate assumption: "...to connect to Oracle 7, I will need oracle 7 client, and to 8, I will need oracle 8 client."

You can connect to an Oracle 7 or Oracle 8 database with whatever version Oracle client you want.

Second inaccurate assumption: "to create a dblink you need an oracle host string created. To create a host string you need oracle client installed."

To create a dblink, you just need a valid username/password combination to the target database and a valid tnsnames.ora alias on the source database-server machine. Client has virtually nothing to do with the creation of the dblink.

So, if you have a working client connection (any version) to an Oracle 7 and/or an Oracle 8 database, and the components in the previous paragraph, you are good to go.

If you have problems or questions, please post.

Mufasa
(aka Dave of Sandy, Utah, USA @ 10:05 (11Oct04) UTC (aka "GMT" and "Zulu"), 03:05 (11Oct04) Mountain Time)

 

[mozgheib]

Thanks for your reply. If I were doing this programatically. For instance I have created a VBA module in access and I am using ODBC to connect to both Oracle servers. The module in the mdb file is sitting on a seperate server. Now to use the odbc drivers I will need to use the ones provided by oracle and not microsoft. Because from experience using Microsofts is problematic. So to use oracles odbc drivers I will need to install the oracle client. Oracle 7 installs oracle 7 odbc and Oracle 8 installs oracle 8 odbc. From experience if I remember correctly I do not think I can use either odbc driver to talk to both Oracle!!!

Please advise.

 

[SantaMufasa]

Mozgheib,

For ODBC issues, we will need help from other Tek-Tipsters (since I am not comfortable assisting with ODBC). My earlier comments apply strictly to creating and using Oracle database links.

Sem, Carp, Turkbear, Dagon, LKBrwnDBA, HimanB, et cetera...Any takers on the ODBC issues?

Mufasa
(aka Dave of Sandy, Utah, USA @ 11:08 (11Oct04) UTC (aka "GMT" and "Zulu"), 04:08 (11Oct04) Mountain Time)

 

[Turkbear]

Hi,
If you insist ( or need) ODBC be aware that any Oracle ODBC driver will connect to any older version of Oracle..( until 9.2 that is, which can no longer connect to a v7 antique)..

Just install the latest ODBC drivers ( since v7 is not involved) and have at it..

 

[mozgheib]

Correct me if I am wrong the Oracle client should always
be the same version as the server or more recent meaning
oracle client 7 cannot talk to oracle server 8 but Oracle client 8 can talk to server 7 and 8?


Thanls.

 

[sem]

Mozgheib, you're wrong. Oracle 7 client may work with both 7 and 8 server (haven't tried with 9 though). It may experience some problems with features like UTF charset or LOB datatypes.

Regards, Dima

http://seminihin.narod.ru

 

[taupirho]

We have installed Oracle9i and still connect to it via our forms5/developer2000 app that previously connected to Oracle V7.3

 

[Turkbear]

Hi,
mozgheib:

Your comment:

Correct me if I am wrong the Oracle client should always
be the same version as the server or more recent meaning
oracle client 7 cannot talk to oracle server 8 but Oracle client 8 can talk to server 7 and 8?



Is essentially what I posted...
Newer --> Older OK,
Older --> Newer May not Be OK

With the caveat about v9.2 client connecting to v7.3 database ( it cannot) - the newer clients are the best to use, IMHO..

 

[sem]

Actually using ODBC is probably the worst solution. My bet is creating db_link. BTW you may manage even without correct tnsnames.ora file on source database by specifying connection parameters explicitely. We used db_links between 7 and 8 in both directions without any problems.

Regards, Dima

http://seminihin.narod.ru