.NET can't pick up the lastest version of stored procedure in CR

[lifeforest]

After i changed the name of the stored procedure in Oracle, and saved in CR2008, .NET still looking for the old version of the stored procedure.

Do i need to dispose the connection in .NET and if so, how? Thanks a lot!!

 

[hilfy]

Try this:

- In the Database menu, select Set Location.
- Create a new connection to the existing database.
- Select the new version of the stored procedure.

-Dell


A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lifeforest]

Hi hilfy,

Thanks for your reply. But the issue here is not Crystal Report file itself. The report running perfectly in CR 2008, but the same file can't bring the correct result if its been called from .NET webpage.

Any ideas regarding this .NET/Crystal Report issue?

 

[hilfy]

Have you published the correct version of the report to your website? How is the connection for the report being set from the web page? Does that need to be updated for the new SP?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lifeforest]

Finally, I figured out. It's not the code can't pick up the latest version, its just that the code didnt point to the right location of the table.

We had code for SQL datasource, something like :

strLocation = crConnectionInfo.DatabaseName & ".dbo." & bTable.Location.Substring(bTable.Location.LastIndexOf(".") + 1)
OutputDebugLine("New Location: " & strLocation)

But this does not work for Oracle. Oracle need to have the fully qualifed name, something like:

c= Split(myReportDocument.ReportClientDocument.Database.Tables(0).QualifiedName, ".")

strLocation = QualifiedName(0) & "." & QualifiedName(1) & "." & QualifiedName(2)

Somehow this doesnt work:
strLocation = myReportDocument.ReportClientDocument.Database.Tables(0).QualifiedName