Knowledge.ToString()

  • FCKEditor JSP Integration Error: The Server Didn’t Send Back a Proper XML Response

    I was having problem to integrate FCKEditor into struts 1.3. I tried to do it as per instruction in the JSP Integration method given on FCKEditor documentation but still I was not able to run it locally. Here is how I installed struts 1.3. http://localhost/jsptest (Tomcat is running on the top of apache) FCKEditor file…

    |

  • Stop SQL Server Trace Using SQL Command

    Today I started SQL Profiler and paused it. After some time, none of the buttons were enabled. I can neither resume nor stop the trace. Here are the sql commands that I finally found to stop the trace. Get the trace id Stop trace

    |

  • Change Database Name in SQL Server

    SQL Server Enterprise Manager does not let you change your database name once you create it. If you want to change your database name, you may have to manually run the following script to change it. First of all you have to login to SQL Server using osql command line utility. Once you are in,…

    |

  • ADODB Command.Execute Does Not Return Error for RAISERROR

    Description I was executing a stored proc which would halt its execution using RAISERROR. When I tried to run the stored proc in Query Analyzer it worked fine and gave me error but in VBA it couldn’t halt the execution and continued to the next statement.

    |

  • MS Access Pass-Through Query Error: Cannot Execute a Select Query

    When I tried to run an UPDATE statement from pass-through query, it throwed error “Cannot execute a select query”. This is due to that fact the property ReturnsRecords is set to True which requires the pass through query to return results. If it does not return recordset, it will throw an error. You can correct…

    |

  • Check the Existence of COM Object Registered Using regsvr32

    I had a chance to work on project which was using a COM object. This object was registered using regsvr32. During application migration to another server, I wanted to check the if this object exists on new server or not. I don’t wanted to write VB application to just check that object so suddenly a…

  • MS Access: Check If The Normal Form Or Subform Form Is Loaded

    If you need to check if MS Access form is loaded or not, you can easily check it using the folloing code This code is good until you are using single form application. This code will fail if the form is used as subform. To search all the forms including subform, I have created a…

    |

  • MS Word: Remove watermark from all Word pages using VBA

    You can create watermark in MS Word document by going to Format Menu > Background > Printed Watermarks… Here you will be able to set Text Watermark in each page. Now if you want to remove the watermark from all pages, use the following VBA script.

    |

  • CodAddict: A New Way to Store and Manage Your Code Bookmarks/Examples

    It was very difficult for me to remember all my code examples and mingle my code bookmark with my social bookmarks. So I came up with a solution to easily store and manage code examples online. The website name is http://www.codaddict.com. I have come up with this name because I am a code addict. I…

    |

  • Flash File (.swf) is Not Loading in IE, Works Fine in Firefox

    I have some video tutorial uploaded on my website. I tried it on FF and it worked perfectly but when I tried on IE, I did not get anything. I checked on google and after spending much time, I found the problem. I am explaining with example. Now IE uses param movie tag to download…

    |