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

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.

delay open file when startup with batch files

I have come across a need to start 2 application during window start up by sequence. The 1st application i call it App1 (C:\application\App1.exe) and the 2nd one i call it App2 (C:\application\App2.exe). Check the below script, REM mean comment in command prompt.

REM set command display to off

@echo off

REM start application App1.exe

START C:\windows\notepad

REM wait for 5 seconds

PING -n 5 localhost > nul

REM start application App2.exe

START C:\windows\notepad

REM exit batch after finish

EXIT

To test it, Open window notepad. Copy and paste code above to the notepad and save as "start.bat". To make it simple for testing, i have change C:\application\App1.exe to C:\windows\notepad and C:\application\App2.exe to C:\windows\notepad.

Double click on start.bat and you can see the batch file in action.

Hope this help.

Ping port

Well, sometimes we need to know whether the port in open or block, we need to do some checking or troubleshoot through ping/telnet. We cannot ping a IP with port but we can telnet certain IP together with Port no.

For example:
Go to open command prompt, if we want to check whether port 21 is working for IP 203.166.87.9 what we need to do is
> telnet 203.166.87.9 21

Method not found: 'Void System.Web.UI.ScriptManager.RegisterStartupScript

Deploy a running web application from one windows 2003 server to another windows 2003 server. The application is running asp.net 2.0 framework with Ajax.net v1, MSSQL 2005.

After deploy everything and run the application, Error message

Method not found: 'Void System.Web.UI.ScriptManager.RegisterStartupScript(System.Web.UI.Page, System.Type, System.String, System.String, Boolean)'

Situation:

In the bin folder, we deploy together with

AjaxControlToolkit.dll

AjaxControlToolkit.pdb

System.Web.Extensions.Design.dll

System.Web.Extensions.dll

After look around and found that the server already installed with the same version but the strange thing is the file size are different from the one i have in bin folder. The first thing can thought of is reinstall the ajax.net.

No luck, after the ajax.net reinstallation, it's not work. Still the same error message:

Method not found: 'Void System.Web.UI.ScriptManager.RegisterStartupScript(System.Web.UI.Page, System.Type, System.String, System.String, Boolean)'

Try to delete all 4 dlls

AjaxControlToolkit.dll

AjaxControlToolkit.pdb

System.Web.Extensions.Design.dll

System.Web.Extensions.dll

from the bin folder but still same error show. So, i undo the deletion.

Try to google around and look for useful suggestion but no luck. All post stated that working after the ajax.net re installation.

Finally, i uninstall the ajax.net from the server and let the application use the 4 dlls

AjaxControlToolkit.dll

AjaxControlToolkit.pdb

System.Web.Extensions.Design.dll

System.Web.Extensions.dll

in the bin files.

It solve my problem.

Hope this sharing helps.

Penang Software House

We are running a software development company Encelabs Sdn Bhd located in Penang, Malaysia. Basically Encelabs provide web application customization like web2.0 community website, facebook application and etc. Encelabs also provided services to develop business software development like eCRM, eProcurement, eRecruitment and etc from A to Z. Some of Encelabs portfolio are listed in Encelabs website.

Feel free to contact Encelabs to know more.

PHP: Warning: split() [function.split]: REG_EMPTY in xxx

I try to php split to split out the concatenated data. Below are the sample that i use

$comp = "V1001|VI003";

$comp_arr = split("|",$comp);

i hit error:

PHP: Warning: split() [function.split]: REG_EMPTY in xxx

after search around and found that the issue is caused by symbol "|".

"|" is an operator in PHP. If want to use the this symbol as a delimiter, we must excape it with a back slash, "\|"

now it become

$comp = "V1001|VI003";

$comp_arr = split("\|",$comp);

and it works.

Hope this help

using jquery in Joomla

I'm developing a joomla component for joomla and involve jquery. It will hit error and need to take special care because joomla ship with javascript framework "MooTools" which will have conflict with jquery.

Here is the code that i pun into my view.html.php

$document =& JFactory::getDocument();

$document->addScript(JURI::base(true).'/components/com_xin/js/jquery-1.3.1.min.js');

$document->addScriptDeclaration ( 'jQuery.noConflict();');

$document->addScript(JURI::base(true).'/components/com_xin/js/validation.js');

in the validation.js

I change all the $ to jQuery.

For example i change

$(document) to jQuery(document)

$('#login') to jQuery('#login')

and all others.

Test again and it works. Hope this help.

LoadLibrary ("xxxx.dll") failed - The specified module could not be found

I've created a dll using VC++ and try to register the dll in the machine xp pro using regsvr32. I copy the dll from my development machine to the deployment and hit error message.

LoadLibrary ("xxxx.dll") failed - The specified module could not be found.

What's go wrong?

I already make sure all my dll dependency copied to the machine. Finally i found out that i should compile the dll in debug mode only. I should compile it in release mode.

I'm able to register to the xp machine after i compile in release mode. Hope this help.

odbc: data source name not found

Situation:

The application written in ASP with dll and etc and use ODBC for database connection. Everything working fine but one day there was a auto windows update can cause this ASP application running with error message "data source name not found". Plenty of time taken for debugging and not solved. Finally by trial and error, the problem solved. Strange, the problem is caused by the permission setting on the dll which call the ODBC. We suspect the problem cause by the windows update and change the permission setting.

Hope this help.