Author Archives: Paul Sturm
IIS7 was causing chrome to reply with ’310 too many redirects’
If you are getting the “Error 310 (net::ERR_TOO_MANY_REDIRECTS):” in Chrome, ensure you still have a default document defined in IIS that is reachable. I had accidentally removed my web.config file on my workstation and, since I don’t use the default Coldfusion document of ‘index.cfm’, my redirect from ‘index.cfm’ to my default document (actually called ‘default.cfm’) was causing [...]
Show line numbers in CFEclipse (IBM RAD, Eclipse)
To turn on line numbers for code viewing: Windows —> Preferences . Use the search box and type in ‘number’
IIS error “The system cannot find the path specified.” after CF removal
I was taking down a site permantently and just wanting to add a ‘retire’ message when, after using the ‘CF web server configuration tool’ to remove the CF mappings on the site, I was getting the error: “The system cannot find the path specified.” I thought the tool would remove the mappings for CFM, CFML, [...]
Excel not opening files
About a month ago, Excel has had trouble opening native files. I could double click an XLSX file and Excel would start only to tell me the file I was trying to open (and just used to launch Excel with) didn’t exists. The following (in a cmd window) seems to have fixed it: “C:\Program [...]
How to determine the current database context in SQL Server
I like to run a check script I’ve crafted that tells me stats on the database before I upgrade and perform schema changes. To make the script more universal, I wanted it to report the name of the database the stats are for (for printing purposes). I knew how to check the database server hostname [...]
How to change the path/move a project in Visual Studio
Close the solution. Rename the folders outside Visual Studio. Open the solution, ignoring the warnings. Go through all unavailable projects. Set the property ‘File Path’ to the new location. Reload the project. In case you didn’t rename the project, rename it (F2). Taken from here: http://stackoverflow.com/questions/211241/how-do-i-rename-a-project-folder-from-within-visual-studio
SSRS: Could not load type ‘Microsoft.ReportingServices.UI.GlobalApp’
I suspect some MS patch caused this as no one has touched this server in months yet today, we got the following: Server Error in ‘/Reports’ Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify [...]
Database diagrams on disconnected devices
If you try to use the database diagram feature in SQL Server Management Studio and the owner of the database is a domain id but you are disconnected from the domain (notebook users!), you’ll get an error like this: “Database diagram support objects cannot be installed because this database does not have a valid owner. [...]
Securing a single file with IIS7
With IIS7's revamped interface, I had a hard time locating how to change the permission on a single file. I could see how to do so at a folder level, but I couldn't see how to do so on a single file (.CFM in this case). It turns out, once you hilghted the file you [...]
8.3 Short filenames on Windows 2003 Server
If you have a document repository of sorts, it may pay to disable short filenames (legacy leftover from Win95 days). To check if enabled: fsutil.exe behavior query disable8dot3 To disable: fsutil.exe behavior set disable8dot3 1 This will not remove existing short filenames but the system will no longer generate them. This also works on XP. [...]