Using Active Data and ODBC Sources in Crystal 9

[asundaram]

Hi,
I've written a report that uses both Active Data (.ttx file) as well as ODBC source to produce a report using Crystal 9 through my VB.NET Application. The report is generated fine, but when i close out of my application, the application continues to hang (the process doesn't quit). This only occurs in Oracle (works fine in Sybase) and in VB.NET (works fine using Crystal 8 in VB). Again the report runs fine, but it causes the application's process to hang. I contacted Crystal, they said they don't support using both Active Data as well as ODBC sources in the same report. However i've been doing this for years in Crystal 8 and 8.5 and it runs fine in Crystal 9 in Sybase and Oracle, but it just causes the process to hang in Oracle. Any ideas as to why this might be happening?
Thanks.

 

[MColeman]

http://support.businessobjects.com/library/kbase/articles/c2008265.asp

Could maybe something similar be happening with your report being ran in .net?

You could add a disconnect for the Oracle database.

 

[asundaram]

Yes, it looks like something similar is happening. If i check the connections to the Oracle database, there is one connection when i start my application. Then a second one appears when i run the report. however, when i close out of my application, the application's Oracle connection disappears, but the Report's Oracle connection lingers.
This only happens when using the Oracle ODBC driver for some reason. How do i call Disconnect?
Thanks.

 

[MColeman]

In your VB.NET code,

connection.close

 

[asundaram]

The problem is the report's independent connection. This gets created when the following code is executed:

CRAXDRT.DatabaseTable.SetLogOnInfo()
CRAXDRT.DatabaseTable.Location()

So how do i explicitly release the connection to this DatabaseTable?

Thanks.