Re: Crystal Reports - Oracle Issue

s_valmont_at_telus.net wrote:
> Guys, just wondering what your input would be on this.
>
> I have Crystal 9 reports which connect to an Oracle 9i database. They
> do this through the ODBC driver provided by Oracle (9.2.0.7.0). The
> problem occurs when I generate multiple reports. The first two
> reports always work, but the third one always results in a Crystal
> object in my code throwing an "incorrect logon parameters" exception.
>
> To me this feels a lot like the DB connections that are being opened
> aren't closed until my entire app is shut down. Is it normal for an
> Oracle DB to allow two connections from the same IP, but then reject a
> third attempt? Perhaps because it exceeds a threshold of two set by
> some administrator?
>
> Thanks.

It is far better to connect to Oracle using the native connectivity. Get as far away from ODBC as you can.

It may not solve your problem but it will still be a good idea.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org