Unix Oracle and SQL 2000

[willem05]

Hi,

I have been surfing for three days on the internet now to search for answers. I hope, with this post, that someone can give me an answer.

Problem:
I need to connect our tru64 5.1A Oracle 8.1.7 database to a SQL 2000 database. I have looking at iodbc.org and unixodbc.org but could not find the solution for me. Everytime I think I found a solution, the software was not free or was for windows - windows systems.
Can someone simply tell me (I just passed the stage of newbe;-) ) how to connect my unix-oracle system to my SQL 2000 server ??? I want my Oracle server to insert data in SQL2000 and vice-versa.

Your help is very much appreciated.

Much thanks in advance....

Greetz,
Willem van Lochem

 

[Turkbear]

Hi,
May not be easy to do( and most likely not free)..
The ODBC drivers ( which are needed to set up Heterogenous connections in Oracle) are platform specific and getting a Unix ODBC client to connect to a Windows ODBC target is not a simple thing to do...

It will be even harder to go from SqlServer to Oracle...

Maybe SAMBA can help, but you would need to ask your Unix admin for more info..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sem]

Another idea is to establish jdbc connection from Oracle stored procedure. Sure, this is not transparent connection (like via db link) and you need some coding.

Regards, Dima

http://seminihin.narod.ru

 

[flstffatboy]

You may be able to use DTS (Data Transformation Services)from SQL Server 2000. I'm not sure if it comes standard with all versions of SQL Server 2000 but it can be accessed within the Microsoft management console. Using DTS you can export/import data bewteen two data sources using many different types of drivers.

FLSTF

 

[willem05]

Hi flstffatboy,

The problem in doing it with SQL-server is that it has to commit record for record. That slows down enormously. That is why the intelligence should be @ oracle..

We are doing it right now with MS SQL DTS...

Thank you for responding however. I appreciate it.

Greetz,
Willem

 

[SimonSellick]

Have you looked into RPC (remote procedure calls)? That's a Java technology (well, it is now) and is aimed specifically at cross-platform and multi-node jobs.

Unfortunately, that exhausts my knowledge of the subject, but I know that Oracle are fairly hot on Java. Web services might be another (related) route to look at.

 

[DBAwhosaysNIE]

I'd use PERL and DBI to write an autonomous "broker" daemon. there's no elegant way to do this. any solution is going to be something of a homebrew hack.