Re: Crystal Reports/Oracle via Internet?

From: Frank <fbortel_at_nescape.net>
Date: Wed, 19 Nov 2003 21:36:48 +0100
Message-ID: <bpgjph$ikm$1@news3.tilbu1.nb.home.nl>

Turkbear wrote:

> 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.
> 
> 
> 
> 

As it *is* Oracle, I suppose SQL*Net comes in place. You state the db is inside the firewall, so I suppose -again- there's SQL*Net between your Web Connector (DMZ) and your db - meaning through the firewall. This firewall should/could be SQL*Net aware, or you use the shared_socket solution.

Just to point out another possibility, namely SQL*Net aware firewalls.

-- 
Regards, Frank van Bortel

Received on Wed Nov 19 2003 - 14:36:48 CST