Re: Crystal Reports/Oracle via Internet?

Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<u20nrvsc3g2lm6pr0k6fcha3d7arqqedmq_at_4ax.com>...
> Frank <fbortel_at_nescape.net> wrote:
>
> >Turkbear wrote:
> >
> >> reijo_us_at_yahoo.com (Reijo) wrote:
> >>
> >>
> >>>Has anyone ever used Crystal Reports against an Oracle DB via the internet?
> >>>
> >>>Any idea how this might be accomplished if, say, the DB was located in a DMZ?
> >>>
> >>>Thank you.
> >>
> >> We do have a server set up for thus, but It is not easy to explain in a posting ; if you do a Google search in the oracle
> >> newsgroups for Firewall - or check the Oracle docs at http://tahiti.oracle.com
> >>
> >>
> >> It involves forcing the listener to use the same port for all communications( and then allowing that port through the
> >> firewall) rather than the default behavior of assigning a random port after the initial connect is made.
> >>
> >> hth,
> >>
> >Hmmm - there *are* SQL*Net aware firewalls. The shared socket approach
> >was broken
> >for Windows in 8.1.6
>
> To be clear..The DB server is not in the DMZ, it is inside the firewall - the Reports that use the data are linked through
> the Web Connector on the DMZ machine..
>
> The shared sockets problem was fixed in 8.1.7 ( but still can cause problems) - works fine in 9.

I have noticed talk on the newsgroup about using CMAN in the DMZ or setting up shared servers (MTS) and specifying the ports to use.

Are there any known limitations or issues/problems with CMAN (or MTS) used in this fashion? Received on Wed Nov 19 2003 - 19:22:04 CST