Re: Accessing sqlserver database from oracle using heterogenous services

From: <>
Date: Thu, 12 Mar 2009 16:02:02 -0700 (PDT)
Message-ID: <>

On Mar 11, 12:38 pm, wrote:
> oracle / sqlserver 2000
> I have set up a database link within oracle pointing to a data source
> (odbc)  which points to a sqlserver instance and a default database
> I can get the following command to work
>  select count(*) from brokers_at_rdt  ...which reads data from the
> default database in the odbc
> If  I try following syntax select count(*) from
> database.dbo.brokers_at_rdt doesn't work
> / Is there a syntax I can use which allows me to use the same oracle
> database link to point to a different sqlserver database on the same
> instance
> or do I have to set up a new link pointing to a new data source
> ( odbc ) with the required target included as default

Did you look at the oracle documentation for this? Received on Thu Mar 12 2009 - 18:02:02 CDT

Original text of this message