Re: Linking SQL Server and Oracle

Hi Martin

Try uppercase for the Oracle side.
eg. select * from linkedserver..SCOTT.EMP

Regards,
Urs

"Martin" <mma0204_at_hotmail.com> wrote in message news:3A006FCD.2AB3687C_at_hotmail.com...
> 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 Thu Nov 02 2000 - 11:48:34 CET