Author: Jacob Saylor

Software developer in Kentucky

SqlCommand.Parameters.Add() vs SqlCommand.CreateParameter()

When doing some quick research on SQL Parameters with SqlCommand, I noticed two methods which seemed to perform the same task, SqlCommand.Parameters.Add() and SqlCommand.CreateParameter().  After looking into each method on MSDN, I noticed that CreateParameter() will simply create the parameter, while Parameters.Add() will create the parameter and add it to the parameter collection. SqlCommand.Parameters.Add() The following example will create a SQL command object, create...

HTTP could not register URL [url]. Your process does not have access rights to this namespace

I was trying to build a project that I inherited (ASP C# ~.Net4) and I got the following error Please try changing the HTTP port to 8732 or running as Administrator. System.ServiceModel.AddressAccessDeniedException: HTTP could not register [url]. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details). —> System.Net.HttpListenerException: Access is denied … System.Net.HttpListenerException (0x80004005): Access...

A connection cannot be made to redirector

I started learning about SQL Server Analysis Services interacting with and using SQL Server Integration Services, and I ran into an issue getting connected to my local server’s Analysis Service. The full error message : A Connection Cannot be made to redirector.Ensure that ‘SQL BROWSER’ Service is running. No connection could be made because the target machine actively refused it. First things first...

Cannot find either column “[ColumnName]” or the user-defined function or aggregate “[ColumnName]”, or the name is ambiguous

I had the following, really simple, issue when adding no locks to my join statements. (I’m relatively new to nolocks since my other applications didn’t require almost immediate concurrent access) Note: Tables names were changed obviously And it was throwing Msg 4121, Level 16, State 1, Line 3 Cannot find either column “b” or the user-defined function or aggregate “b.index”, or the...