Skip to main content

Posts

Showing posts from May, 2007

CR9 to CR XI Upgrade

Since last couple years we have been using Crystal Reports 9 as our reporting tool with applications developed in VB6. Recently we deployed a new Staging server just to find out that we couldn't make CR 9 work on it. No matter how many DLLs we installed/uninstalled, the crystal report viewer would not load. I called up Business Objects Support, once again just to find out that they do not support CR 9 anymore. I finally made the call to upgrade our reporting tool to Crystal Reports XI version. To all of you out there wanting to upgrade your CR9, I would suggest you upgrade to CR XI and CR 10 as I have heard (rumors) that support to CR 10 ends December 2007. I had to go around in a circle to get somebody to tell me a short and simple process to upgrade from CR 9 to CR XI. I got it and found it very useful so here I share it with you! If you find it useful let me know! What you will need: Crystal Reports XI, Developer Edition (to develop and integrate with VB6 / .NET application) VB6

DTS Package - 'Invalid Pointer' error

Earlier this morning, I was creating a DTS package to get data from a particular query and inserting in to an Excel File. The query worked just fine in Query Analyzer and the Excel table (worksheet) column definition also exactly matched the query output. But, as it always happens - an error keeps on popping up when you are in time crunch, I kept on receiving 'Invalid pointer' error. I tried changing the variable names, data types etc and nothing worked. Finally I realized that the cause of failure was some sort of unwanted output from executing the query. I fixed this issue by adding SET NOCOUNT ON towards the top and SET NOCOUNT OFF at the bottom of my query! Hope this post will be useful to you at some point in time!

Hello World!

I have been employed as a Systems Developer since last four years and during these four years many a times I have sought help from various blogs. I believe now that I have enough experience to blog about SQL and VB6 and thereby share my experiences with others in the community. Welcome to my blog - 'SQL, VB etc'!