Re: development tool for oracle and sql server

From: HansF <News.Hans_at_telus.net>
Date: Sun, 16 Apr 2006 21:26:51 GMT
Message-Id: <pan.2006.04.16.21.20.41.751648@telus.net>

On Sun, 16 Apr 2006 10:40:55 -0700, jbmorla wrote:

> Maybe simply Microsoft Access via odbc for Oracle and odbc for sqlserver?
> You don't need the rowids in Reports? I checked OTN but I can't find out
> if Oracle Reports has a gateway to SqlServer.

Even if it did, I'd probably consider using the (included) Heterogeneous services in Oracle and simply make the SQL Server look like a remote Oracle database. That way I could use the capabilities of Oracle, such as the analytic functions (that are available even in Oracle Express Edition) to reduce the data set.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Sun Apr 16 2006 - 16:26:51 CDT