Re: Crystal Reports/Oracle via Internet?

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 19 Nov 2003 08:40:46 -0600
Message-ID: <u20nrvsc3g2lm6pr0k6fcha3d7arqqedmq@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. Received on Wed Nov 19 2003 - 08:40:46 CST