Re: connecting oracle reports 9i to another database via odbc...possible?

Look into the docs for heterogeneous Services ( I think) - It allows you to add any ODBC compliant database to the Oracle http://tahiti.oracle.com is a good place to search if you do not have actual docs on hand...

Personally, I prefer Crystal Reports for my mixed environment reporting setup and with Crystal Enterprise you can quickly publish the reports for web-based access...

pheonix1t <9090pheonix1t.at_at_earthlink.net909090.oio> wrote:

>hello people,
>I'm in the middle of trying to determine which report tool is a better
>choice for a customer site. They are running oracle 9i, 8.0.5 and some
>other database on an SCO server for a medical app. They currently
>connect to that DB via odbc for doing reports using foxpro, report
>writer and approach!
>So, I've come down to either using ACCESS or oracle reports. On the
>docs and tutorials, it mentions reports can connect to any data source.
> I've tried playing around with it, but don't see where to set the odbc
>on reports to see other sources. It has settings for text, XML, other
>oracle databases...stuff like that.
>Has anyone done this? I just want to know if it's even possible before
>I go and read all sorts of docs and books on oracle reports 9i.
>I tried browsing the docs site and several docs, but no luck.
>
>Thank you and happy new year to all :)
>
>
>Oskar
>
>
Received on Tue Dec 31 2002 - 15:38:04 CST