Use Advance Drawing Toolbar
Monday, 15 March 2010
Sunday, 7 March 2010
Sunday, 21 February 2010
Failed to open a rowset. Details: 42000:[IBM][iSeries Access ODBC Driver]Statement violates access rule: Connection is set to read only. Failed to open a rowset.
This is very common error when you try to deploy your Crystal Report reports in production environment. But most of the time people doesn't have proper solution. This error can be raised due to various reasons. But as I feel Crystal report gives very generic errors rather giving specic error message. So that most of the time we need to spend lot of time to figure out the exact issue. As of my experience this error gives when your crystal report unable to retrive data from your database properly. Here in this case iSeries Acess ODBC Driver has used. You might use some other driver to communicate with your database. But you will get very similar error with respect to your driver. Whether you are using stored procedure to retive data or directly access the database table; doesn't matter this error might occur.
First thing that you can try out is check whether you have configured "AllowProcCalls" registry entry. You can check this, go to start button, then run. In run dialog box type "regedit" and enter. In the RegEdit you need to locate HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Then find your ODBC data source that your crystal report retrive data from. Verify that there is an entry called "AllowProcCalls" with a value of "1". If AllowProcCalls entry doesn't exists you can create it by right click on your ODBC data source, then select New : String Value. Enter in AllowProcCalls and enter. If AllowProcCalls entry has value other than 1 you can change its value by double clicking on that entry or right click on the entry and select modify. Enter 1 and press "OK".
This is very common error when you try to deploy your Crystal Report reports in production environment. But most of the time people doesn't have proper solution. This error can be raised due to various reasons. But as I feel Crystal report gives very generic errors rather giving specic error message. So that most of the time we need to spend lot of time to figure out the exact issue. As of my experience this error gives when your crystal report unable to retrive data from your database properly. Here in this case iSeries Acess ODBC Driver has used. You might use some other driver to communicate with your database. But you will get very similar error with respect to your driver. Whether you are using stored procedure to retive data or directly access the database table; doesn't matter this error might occur.
First thing that you can try out is check whether you have configured "AllowProcCalls" registry entry. You can check this, go to start button, then run. In run dialog box type "regedit" and enter. In the RegEdit you need to locate HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Then find your ODBC data source that your crystal report retrive data from. Verify that there is an entry called "AllowProcCalls" with a value of "1". If AllowProcCalls entry doesn't exists you can create it by right click on your ODBC data source, then select New : String Value. Enter in AllowProcCalls and enter. If AllowProcCalls entry has value other than 1 you can change its value by double clicking on that entry or right click on the entry and select modify. Enter 1 and press "OK".
Tuesday, 5 January 2010
MD5 Hash code is a unique string of characters that can be generated for a given character string. This Hash code is very important when you compare string values. It is not technically correct to compare two string directly. Good method is generate Hash code for both the strings and compare those Hash codes. Virtually it is agreed that accuracy of Hash code comparison is much higher. Not only to compare two strings, we can use Hash code to compare two files as well. There it is required to read a file as byte stream and generate Hash code for that stream. To compare that stream with second file you need generate Hash code for second file as well using same method and compare those Hash codes. Using this method you can check whether any changes has happened to the content of the file as well as meta data of the file. So that MD5 Hash code is really important in various scenarios. Most of the programming languages are directly support for MD5 generation. Even SQL commands are available to generate Hash code directly at database level. Here I am explaining one of the methods that can be easily used.
Figure 1: Structure of drive system
Load is the most important component. All other units are arranged to serve the requirement of the load. Any design begins with a list of specifications for the load. This depends on the type of the load and its environment. We need to answer several questions before preparing specifications.
Role of power electronics and drivers
- Power controlling using electronics consider here
- Signal controlling is consider about controlling information
Power electronics is about control of power electronically. Range of power can extend from some fraction of watt to several mega watts (MW). Drives are about the control of mechanical motion. It can be a linear motion, rotary motion or their combination. There is a greater compatibility between power electronics and drives as the former can provide smart control of power for the drives. This is evident from the varieties of fascinating motion control systems we find today.
Monday, 29 June 2009
If you try to insert single quote into DB2 sql table directly, it will give an error message due to single quote is reserved for mark a string value in sql. It is not allowed to use escape sequence for single quote with sql. Below example is incorrect with sql syntax.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\'s Company')
Here middle single quote is not valid even it has used the escape sequence. The easiest method to insert single quote into sql table is replace single quote with double quote.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\"s Company')
In second example I have replaced the single quote with double quote, but once you execute this command it will insert single quote instead of double quote.
You can use following code in C#.NET to replace single quote with double quote.
Replace("\'", "\"")
If you have any question you can list them under comments section.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\'s Company')
Here middle single quote is not valid even it has used the escape sequence. The easiest method to insert single quote into sql table is replace single quote with double quote.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\"s Company')
In second example I have replaced the single quote with double quote, but once you execute this command it will insert single quote instead of double quote.
You can use following code in C#.NET to replace single quote with double quote.
Replace("\'", "\"")
If you have any question you can list them under comments section.
Monday, 8 June 2009
If you have used Crystal Report (Crystal Reports 2008 Official Guide
) with Microsoft ASP.NET, you might have face this issue many times. This is a common problem with Crystal Report deployment and many people don't have proper solution for the problem. Crystal Report Toolbar images not shown in deployed environment is one of the main inconvenient with the tool that is leaded many developers not to use Crystal Report tool as their reporting tool even though Microsoft Visual Studio distribute Business Objects Crystal Report Tools free of charge. Even though your report is perfectly working inside the report viewer, it is not useful if the report viewers toolbar is not working properly. You can not navigate through multiple pages, can not export your report, can not print the report...etc. So that it is equally important to work your report and report viewer both correctly to feel end user happy reporting experience.
Posts
