Re: Accessing sqlserver database from oracle using heterogenous services
From: <johnbhurley_at_sbcglobal.net>
Date: Thu, 12 Mar 2009 16:02:02 -0700 (PDT)
Message-ID: <9ca0922d-c383-4cbd-ae08-bf1d3adf1b38_at_j8g2000yql.googlegroups.com>
On Mar 11, 12:38 pm, chris.br..._at_providentinsurance.co.uk wrote:
> oracle 10.2.0.4 / 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 ...it 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
Date: Thu, 12 Mar 2009 16:02:02 -0700 (PDT)
Message-ID: <9ca0922d-c383-4cbd-ae08-bf1d3adf1b38_at_j8g2000yql.googlegroups.com>
On Mar 11, 12:38 pm, chris.br..._at_providentinsurance.co.uk wrote:
> oracle 10.2.0.4 / 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 ...it 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