Linking SQL Server and Oracle

Hello,
I need to find the best method for importing Oracle tables into SQL Server while updating a pull flag in Oracle at the same time. We thought of several approaches, but we are unable to decide which approach is best and fastest.

I tried connecting Oracle via OBDC with Access. Using Access I am able to get external data from Oracle. I am able to see the table defs and data. I am also able to update the data in Access and the updates are done immediately in Oracle.

We are trying to do something similar in SQL Server 7.0, but are not able to connect successfully. The ODBC settings work because we successfully ran queries using Oracle's OBDC Test program. However, when I try the same query in SQL Server, the query runs without stopping.
In SS, I am able to connect to Oracle successfully. I see the Oracle table names in Linked Servers. SS Help says I need to qualify the table

name with linked_server_name.catalog.schema.object. However, the catalog value for all tables in Oracle is nulls. I tried the following "select * from linksvr..schema.table, but that doesn't work.

Any ideas??
I'm developing on Win95, but this will eventually be installed on an NT box. Received on Wed Nov 01 2000 - 20:32:30 CET