Verify Database question

[Howardx]

I'm using .NET 2003, C# and the version of crystal reports that is included. I am repeatedly having problems where right clicking "Database Fields" and selecting "Verify Database" does not work as I am expecting it to. Even if I have changed the underlying stored procedure I will get "The Database is up to date.". When this happens I start to do things such as deleting my datasets and adapters and although I haven't found an exact sequence that I can repeatedly use I eventually seem to get to a point where it finally recognizes that the stored procedure has been changed. Ideally I'd like to understand why this is happening and I'd like to know if there is a menu option or command that allows you to force the refreshing of the stored procedure even if Crystal thinks it is the same. I will also throw the one caveat out there, any answer involving removing and re-adding the database on the report is unacceptable unless it includes a way to preserve the field formatting. A few times in disgust I've done this but then had to drag all the fields back on the report, renter all the formulas, etc.

Ok long question/description, thanks in advance for any ideas you might have.

 

[synapsevampire]

In regular Crystal there is a Database->Verify Database menu choice.

In regular CR and using ODBC, you have to make sure that you use the Crystal supplied ODBC with the appropriate settings in the driver.

Also make sure that you apply and service packs and hotfixes too:

http://support.crystaldecisions.com/fix/hot/si75/?ref=default.asp_selectlist

There's a .net service pack there.

-k

 

[Howardx]

Thanks for the thoughts on this. I had applied the service pack as it was recommended in another thread but it did not help. However I think I have found something that works, at least it worked today, I'll have to try it a few more times and hope it holds true. Instead of just generating the dataset and/or deleting my Data Adapter and Datra set and recreating them, I went to the properties of the Data Adapter and clicked on the ... of Table Mappings. There is a reset button in there and it worked on bringing in the newest stored procedure. After I did that when I went into the Crystal report the Verify Database worked.

 

[Howardx]

Bah, I just had the problem again and the above did not work for me. I actually did a complete shutdown (not restart) and after powering up the verify database button worked. Leads me to believe that somehow something is being cached. And it seems to be a hardcore type of caching because quitting Visual Studio does not seem to be enough to resolve the issue. I'd love to know what is really going on.

 

[synapsevampire]

That is odd...

What kind of database is it?

Have you tried doing a set location (should be under Database) and pointing to the data source again? Make sure that you refresh the data sources in the data explorer by selecting the connection and pressing F5.

-k