Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR9 ConnectionProperties with Oracle

Status
Not open for further replies.

TelesW

Programmer
Jul 15, 2002
3
BR
Hi All

I have some reports that run without problem on CR8, retrieving data from an Oracle DB using Native Connection. These reports are on a web enviroment and are called throught ASP using RDC. The method I'm using to connect to oracle is the SetLogonInfo.

Now I'm upgrading my platform with CR9 and I discovered that SetLogonInfo is deprecated. Even if it is not deprecated I cannot do it run properly with reports that have subreports. Cr gives me this error:
(CRAXDRT Error Occured on Server. -2147189182 : Query Engine Error: 'This operation is not valid for a closed connection.')
With plain reports no error occurs.

Searching on Crystal Support Site I discovered some exemples on how to use ConnectionProperties method. A new methos implemented on RDC but no specific exemple for a native connection to Oracle Database.

Is there someone that is already using ConnectionProperties With Oracle and can sent me an exemple on how to do it?

Thanks a lot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top