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.

For those connecting through a firewall, are you using Advanced Security for encryption?

Thanks. Received on Wed Nov 19 2003 - 14:56:30 CST