Author: Ryan Garaygay

  • Reading SQL error messages and sp_executeSQL

    "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." A few days ago, I ran into the error mentioned above. sp_executeSQL requires that the first two parameters (statement and parameter declaration) be of type ntext, nchar or nvarchar http://dotnetjunkies.com/WebLog/richard.dudley/archive/2004/09/29/27169.aspx When I ran into this error, I copied the error message and googled (so much for the "googler…

  • New Programming Stereotypes

    I've enjoyed reading (and I think most of you two) this one from Scott Hanselman so posting it here. http://www.hanselman.com/blog/BeyondElvisEinsteinAndMortNewProgrammingStereotypesForWeb20.aspx Behind the funny descriptions it makes us think where we fit in and somehow understand why that guy in the corner of the office behaves the way he does and yes one of the reasons…

  • HTTP 403.9 – Access Forbidden: Too many users are connected

    I was trying to test multiple connections to my local IIS server when I got the http status/error code above. This is because there is a limit to the number of concurrent connections with Keep-Alive Enabled setting ON. http://www.experts-exchange.com/Web/Web_Servers/IIS/Q_20286298.html So I unchecked "HTTP Keep-Alive enabled" and the issue was resolved. But when I run/debug from…

  • ZoneAlarm and localhost

    Regardless of privacy settings, ZoneAlarm will always rejects cookies when using localhost. Something that is not very developer friendly. The work-around is to use 127.0.0.1 instead. If you are using Visual Studio, you can set whether to use IIS and have the starting url to use 127.0.0.1. At least that how it works for ASP.NET…

  • Deleting sub-directories (folders) in ASP.NET 2.0 restarts the AppDomain

    All the while I thought that the AppDomain only restarts when the web.config, global.asax, bin folder (or it’s contents) is changed and if there are considerable number of files have changed (15 is the magic number as they say but can’t verify). All the while I was wrong, by default (that is without tweaks), deleting…

  • Missing Visual Studio Recent Project/File list

    Either you just missed to add it in your Menu (Tools > Customize – take it from there) or you have set your windows to not remember your most recent document list. Yes Visual Studio depends on the windows setting. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=108731

  • SSL and SQL Server 2005

    Getting an "error occured during the pre-login handshake". in SQL Server? I just spent the last few hours trying to figure out why I can't connect to my local SQL 2005 instance and getting the error above. I was using SQL Management Studio. I tried tweaking Network/Client Configuration, Protocols using SQL ConfigurationManager, Surface Area Configuration…

  • Tool List

    Aside from essentials installations here are some of the application I have on my PC which proved useful to me so you might as well look into. Will post the links soon. General TimeSnapper Pro Diskeeper Pro Premier Ad-Aware (Free) Spybot S&D (Free) Windows Defender Zone Alarm (just turned Pro) HiJackThis (Trend Micro) RSSReader TuneUp…

  • Microsoft Second Shot Exams are back

    http://www.microsoft.com/learning/mcp/offers/secondshot/default.mspx Testing Centers in the Philippines: http://www.microsoft.com/philippines/learning/ (these are learning centers but they are the most common exam centers too) http://www.register.prometric.com/ClientProgram.asp (list from Prometric, just follow the links) Microsoft Learning start page http://www.microsoft.com/learning/default.mspx According to the FAQ, “You must take the first exam between September 15, 2007 and January 30, 2008. If you don’t pass,…

  • Welcome to my new Tech Blog

    I have my tech blog setup at last (need a little more modifications like themes etc but it's here). I was thinking of coding the blog features myself but I figured it would require more than I currently have so I'm using BlogEngine.NET instead. It will also be a good way for me to get…