Re: Accessing sqlserver database from oracle using heterogenous services

From: Michael Austin <>
Date: Thu, 12 Mar 2009 17:10:17 -0500
Message-ID: <tJful.9477$> 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

"doesn't work" is very descriptive... can you elaborate? have you checked the log files Received on Thu Mar 12 2009 - 17:10:17 CDT

Original text of this message