Author: Ryan Garaygay

  • Problem with SQL Database Mail: ExternalMailQueue missing

    UPDATE: Just wanted to point out that it's likely that this issue was after installing .NET Framework 2.0 Service Pack 1 (SP1) I just updated an entry in the technet forums regarding a previous issue I've encountered before. I was able to solve my issue by reinstalling SQL Server (which is not a very brilliant…

  • Cool Commands addin for Visual Studio

    The collapse/expand all project and the open containing folder (plus other features) would save time/effort so check out this addin from Gaston Milano. I've tried this out myself for sometime already and didn't get into any issue so go give it a try. http://weblogs.asp.net/gmilano/archive/2005/11/10/430240.aspx

  • Viewing email messages sent from .NET code

    There are a number of times that we need to test just the content of the email we send from code. (eg. text and formatting is correct) without actually needing to send the email. You can dot this by setting the smtp client's DeliveryMethod property to SmtpDeliveryMethod.PickupDirectoryFromIis. Of course this assumes that you use System.Net.Mail.StmpClient.…

  • 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…