Database Connection

[Crider]

I have been working on forms that have lots of sections. I am developing a given form in sections building the stored procedures as I go along. I am also using sub reports in these sections because of the nature of the forms. I just find it easier and feel I have more control. My problem is after a while, when I go to link a new stored procedure to a new sub report, I can't get a new connection to the database. When I expand the stored procedures list, the stored proc that I built doesn't show. The only way I've been able to get around this has been to end Crystal and start it back up again. I do refresh the available data sources window but the same thing happens. Is there some way I can reconnect to the database such that I can see any new objects without having to exit Crystal? If it makes any difference, I am using SQL Server 2000 and Crystal 9.0

 

[GJParker]

Have you tried Database menu, Verify Database ?

Gary Parker
Systems Support Analyst
Manchester, England

 

[Crider]

I have tried that and that doesn't solve my problem.

 

[Crider]

I think I found my problem. Apparently if sufficient time elapses, Crystal drops the connection to the database. If however, the connection is still present, then clicking Database/Log On Log Off Server and logging off the server will do the trick.