Sunday, July 27, 2008

Troubleshoot: [CrystalReport .NET] Database Logon Dialog Keep On Apppearing

For those who are heavily involved with CrystalReport especially CrystalReport .NET version might notice some 'unwanted' things happen sometimes after deployment of a project. I involve a lot on VB.NET programming which used CrystalReport as its reporting services and one of the regular thing I face was a problem in which Database Logon dialog keep on appear itself asking you to enter username, password, server, etc. However, this dialog keep coming out even after you fill in the required field. In most cases, this problem does occur in certain machine only.

After trying and trying few ways (and this is always the way you'll finally solve the prob), finally I come to this solution and maybe conclusion. I couldn't guarantee this solution may apply to all. But maybe for those having similar trouble, can put this on try...

ENVIRONMENT
============
VS .NET 2003
Crystal Report for .NET 2003
Win XP Service Pack 2

SYMPTONS
==========
generate a report, suddenly "Database Login" dialog appear, whatever things you write on (server, username, pwd, etc)you'll still get this error message.


REASON
=======
Absoulue reason of this problem is still unknows, but one of the reason is bacause dll file used to read XML Schema (*.xsd) is corrupted or unable to do intented job.

SOLUTION
=========
Easiest way is by copying the whole files from folder "C:\Program Files\Common Files\CrystalDecision\1.0\bin" FROM (PC which doesn't have this problem) TO the same location at the 'problem' PC.

If GOD permits, everything works fine later!

No comments: