Re: Accessing sqlserver database from oracle using heterogenous services
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 12 Mar 2009 17:10:17 -0500
Message-ID: <tJful.9477$%54.1761_at_nlpi070.nbdc.sbc.com>
chris.brown_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 17:10:17 -0500
Message-ID: <tJful.9477$%54.1761_at_nlpi070.nbdc.sbc.com>
chris.brown_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
>
"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