Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Accessing different Oracle versions from C# applikation

JJespersenMar 1 2018 — edited Mar 12 2018

Hi folks,

I'm new to Oracle development. There, I said it. I've been accessing MS SQL databases for a llllooooonng time, but this Oracle stuff is getting to me. But I'm not here to start a bitchfight, just to get some pointers, hints, ideas or examples for how to solve my problem. Then I will love Oracle for as long as we both shall live.

So....

I have to different Linux servers, Server A running Oracle 9.2 and Server B running Oracle 12.2.
I also have a Windows Server (2008R2), on which i need to run an application. The application is very simple. Read data from DB on Server A, and insert into DB on Server B.

Now, as I understand it, database links between 9.2 and 12.2 are not possible, and from my (limited) experience, I cannot use the same driver/provider from C# for accessing both 9.2 and 12.2.

What would be the basic, ideal approach for solving this. What are the prerequisites (drivers, providers, clients (yes, I'm confused about these)) that are needed?

Any input is very welcomed.

Thanks,
J.Jespersen

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 9 2018
Added on Mar 1 2018
5 comments
1,170 views