Pages

Search This Blog

Thursday, December 17, 2009

Failed to create the Crystal Query Engine Visual Studio 2005

When try to open crystal report in VS 2005, error message appear "Failed to open document" and followed by message "Failed to create the Crystal Query Engine".

I believe it same case with what discuss in http://social.msdn.microsoft.com/Forums/en/vscrystalreports/thread/79e1da80-f5c6-42fa-80ca-65a10de5729d .

The root cause maybe because of installation and uninstallation of merge module. Many recommend that we remove the crystal report, after that add crystal report back to visual studio. Steps below

  1. Go to Add/Remove Programs and select Change/Remove for Microsoft Visual Studio 2005
  2. Select Next then Add or Remove Features from the Visual Studio 2005 Maintenance Mode app
  3. Uncheck Crystal Reports for Visual Studio and select Update
  4. Once the "Update" is complete, select Finish
  5. Go back to Add/Remove Programs and select Change/Remove for Microsoft Visual Studio 2005
  6. Select Next then Add or Remove Features from the Visual Studio 2005 Maintenance Mode app
  7. Check Crystal Reports for Visual Studio and select Update
  8. Insert Disk 1 of Microsoft Visual Studio 2005 Installation CD's and select OK
  9. Once the "Update" is complete, select Finish

But in my case, i don't have installation CDs with me. So, i try an alternative way to get it work. You can try it but at your own risk.

I have another development machine which i call it machine B which have VS 2005 with crystal report install and working fine. The one have problem, i call it machine A. What i do is:

1. go to machine B, go to folder C:\Program Files\Common Files\Business Objects\2.7
2. copy the whole bin folder to a external drive or pendrive or thumb drive
3. close the visual studio 2005 in machine A if it's open
4. go to machine A, go to folder C:\Program Files\Common Files\Business Objects\2.7 and rename the bin folder to binA for backup purposes
5. copy the bin for the external drive to C:\Program Files\Common Files\Business Objects\2.7 in machine A
6. try to open visual studio 2005 and open the crystal report development file.
7. it working

It solve my problem especially when i don't have the installation cds with me at the moment. Hope this help

Saturday, December 12, 2009

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - data1$" (1)

Trying to import data from a text file using MSSQL2005 SSIS import and export wizard to import data from email.txt into MSSQL data and found below error.

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - email_txt" (1)

Surf around and found that it's a bug for MSSQL2005 SSIS and have fix in MSSQL SP2. So, try to download SP for mssql and it do solve my problem.