RR Report Writer in Win 2000 & XP
Posted: Thu Apr 18, 2002 4:17 pm
At the company that I work for I ran into a problem with rswrun.exe version 6.0. This is the 16 bit dos application. Users were getting errors when trying to run reports in VB. The VB program would create a txtfile that contain search parameters. The VB app would shell out and call rswrun.exe and pass the location of this file to rswrun.exe and would pass the location where rswrun.exe could create a text file that contained status of the reports ran. Well here were what the problems were:____1. Windows 2000 & XP use long file and folder names. So the command shell will not format your path to short names. The 16 bit rswrun.exe could not handle long file names.____2. The text file that was created that has parameters so that the rswrun.exe can query SQL, can not be created on the Root of "C:" drive if they are not administrators. If they are in the Power User group they will not have rights to create files on the Root Drive.____3. The status file that rswrun creates, cannot be in a location where the path is longer than 30 characters.____We solved these problems by, formating the paths to short names before we passed it to rswrun.exe, moved the file that gets created on the Root of "C:" to the location that the application resides in, and finally, we made sure that the path that we was writing the status file to was not longer than 30 characters.