Lee's Development Blog

tag:blogger.com,1999:blog-88129622335327405762012-02-16T11:09:48.295-08:00Lee's Development BlogMy personal blog that allows me to share and remember things I have found while developing software using ASP.NET, SQL Server, Windows SharePoint Services, InfoPath, and anything else.Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.comBlogger241100tag:blogger.com,1999:blog-8812962233532740576.post-23591740665534985172009-09-28T14:11:00.001-07:002009-09-28T14:14:48.415-07:00Using ISA as a Proxy Server in your ASP.NET apps

If the web server your web application or web service is running on is accessing a resource on the outside (a 3rd party web service for example) and it cannot, it could be that the web server your application is running on has an internal IP address. The issue is that it is not being instructed to use ISA as a proxy server. There are a couple of ways of doing this, but one way that has been

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com1tag:blogger.com,1999:blog-8812962233532740576.post-55809729395710465282009-08-03T12:24:00.000-07:002009-08-03T12:26:26.349-07:00Better SQL Server Security - How to protect your database

I have a database that was created for a custom application. The application may be broken up into multiple tiers or not. All interaction with the data is done using stored procedures. My problem is that I want to constrain my end users to accessing and executing the stored procedures through the custom application and nothing else. That means the user should not be able to go applications like

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-86964301476952398232009-04-20T09:14:00.000-07:002009-04-20T09:15:49.963-07:00Global.asax Session_Start code not running

We were moving an ASP.NET 2.0 application from IIS 6 to IIS 7 and we ran into a problem. The code in the global.asax Session_Start was not running. However, this code had been running fine in every environment (development, testing, production) in IIS 6. Through a lot of research and trial and error, we figured out a solution to the problem. I’m not sure the problem was necessarily with IIS 7

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-39816353635837536642009-04-09T12:09:00.001-07:002009-04-09T12:09:57.158-07:00Job hangs when running SSIS package

I had a SSIS package that I modified and put out onto a development server. When I ran the existing job, the job would hang. Based on troubleshooting, it would appear the package would not even begin to start. When the package was executed from the development PC, it ran fine. When remoted into the SQL Server and ran the package in BIDS, it ran fine. However, when we ran in a command line

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-54329020721040997622009-03-30T10:38:00.001-07:002009-03-30T10:39:08.318-07:00Kerberos and SharePoint

Great link on Kerberos and SharePoint. Probably one of the best descriptions of how Kerberos really works.http://www.sharepointjoel.com/Lists/Posts/Post.aspx?List=0cd1a63d%2D183c%2D4fc2%2D8320%2Dba5369008acb&ID=2

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-87139907999896008132009-01-12T08:43:00.000-08:002009-01-12T09:28:28.788-08:00Quickly adding data to SharePoint List

I was working on a SharePoint project where I needed to quickly add 100’s of list items to a list. The list was not your ordinary list. The list had the following column types.TextPerson or Group (Show Name field)Person or Group (Show Account)Yes/No (default Yes)Lookup (based on a “division” list)This list was to store a list of approvers for a workflow application I was working on. The Person

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com4tag:blogger.com,1999:blog-8812962233532740576.post-78273208445006468302008-11-24T11:55:00.000-08:002008-11-24T11:56:22.028-08:00Validation of viewstate MAC failed as a result of 3.5 SP1

On the eve of installing the 3.5 SP1 framework on our production IIS servers, I uncovered a problem on our development server. Today I went to use a rather old application 2.0 on DHSIISD1 for a totally unrelated note and found that it was getting a runtime error. The error that was being produced was as follows.Validation of viewstate MAC failed. If this application is hosted by a Web Farm or

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-26538181964272593262008-10-06T10:09:00.001-07:002008-10-06T10:09:50.228-07:00Understanding Kerberos and Service Principal Names (SPN)

The best explanation and tool for troubleshooting problems with Kerberos and delegation in an IIS environment.http://blogs.iis.net/brian-murphy-booth/archive/2007/03/09/the-biggest-mistake-serviceprincipalname-s.aspx

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-750185290111641702008-09-09T09:46:00.000-07:002008-09-09T09:47:04.943-07:00Nice Free Geocoding Web Site

I needed to be able to quickly geocode some addresses and this site did just that AND it was free.http://www.batchgeocode.com/

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-4217306176993338462008-08-06T09:09:00.000-07:002008-08-06T09:11:26.730-07:00Method to pass multiple "parameters" to a stored procedure using XML

I want to share with you a technique I have devised. I had a case where there was a stored procedure in a database that allowed you to look something up based on a parameter. The problem I had was that I needed to do this lookup anywhere between 1 – 200 times depending on the circumstances. I really didn’t like the idea of calling the stored procedure 200 times, so I looked into another way.

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-84390079606506013522008-07-16T09:44:00.000-07:002008-07-16T09:45:42.917-07:00Running SSIS Package gives: error failed validation and returned validation status "VS_NEEDSNEWMETADATA"

When running a SSIS package with a data pump task, if you receive an error similar to failed validation and returned validation status "VS_NEEDSNEWMETADATA" the problem could be that the security for the account running the package is not setup for the object being called within the data pump task source task. In the case this was found, the data pump was calling a stored proc in another

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-676670980670653362008-07-03T14:13:00.001-07:002008-07-03T14:15:44.151-07:00Get list of AD group members

Quick and dirty way to do this.using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.DirectoryServices;namespace ADTest{public partial class Form2 : Form{public const string adpath = "LDAP://domain.com/";public Form2(){InitializeComponent();}private void button1_

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-59485948340051178742008-06-26T08:43:00.000-07:002008-06-26T08:44:00.044-07:00Problem Connecting to SQL 2005 Named Instance with Vista

If you are running Vista and you are using Management Studio or an application that is connecting to a SQL 2005 named instance server, you will receive the error.Login timeout expiredAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-74432460249342925712008-06-20T13:16:00.000-07:002008-06-23T08:19:15.678-07:00Using Access 2007 as a conduit to SharePoint list data

I stumbled onto something today that I don’t know what to think of and thought I would kick it out to the world for comment. I was grappling with the idea of using “data” in lists that exist in a site collection. By using, I mean using in the since of reporting on it, integrating it with other data sources (SQL Server, web services, etc), etc. I knew that Access 2007 had native capability to

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-90442593041827851292008-06-20T07:34:00.000-07:002008-06-20T07:37:54.455-07:00Problem with Site Navigation in SharePoint

When I tried to do something in a site's Navigation, after clicking the OK button, I would get this SharePoint error.Microsoft.SharePoint.Library.SPRequestInternalClass.MoveNavigationNodeIt turns out this is because a Heading somehow has an invalid link. The only way I found to fix this is to go into SharePoint Designer and change to the Navigation pane and delete the offending headings. You

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-78159480659535702712008-04-30T06:18:00.000-07:002008-04-30T06:19:00.139-07:00Free Microsoft Training

A good resource on training from Microsoft.http://www.isvinnovation.com/

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-74063819929847759572008-04-25T11:19:00.001-07:002008-04-25T11:22:44.710-07:00Mapping a folder to the GAC

Here is the command to map the GAC folder to a driveStart->Run->cmdsubst g: c:windowsassembly (with the backslashes in the right spot)Open G: drive in Explorer

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-10885145867023067902008-04-24T14:27:00.000-07:002008-04-24T14:31:50.430-07:00Weird GAC issue

I was doing a WSS Application Page (first time to do this) and found a weird behavior. When I went to test the page, I would get an "File not found" WSS error. I would go back to my code and review it and make a couple of changes and redeploy it. Then it would work. Then I would make a simple change, redeploy it, and then it would break. It turns out it was a problem with the registering of

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-43985262051836311902008-04-24T14:18:00.001-07:002008-04-24T14:19:02.865-07:00Scan directly into SharePoint

I recommended this product to my client. It allows you to directly scan a document from a desktop into SharePoint. It works really well and is easy to setup. And for the price, it isn't a bad deal.https://www.darkblueduck.com/Default.aspx

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com1tag:blogger.com,1999:blog-8812962233532740576.post-85537732538336097242008-02-29T07:28:00.000-08:002008-02-29T07:31:23.827-08:00easyPDF

While looking into the ability to convert an InfoPath form to PDF, I came across a product called easyPDF from BCL Technologies. They have an SDK that allows you to work with their "virtual" printer. At the current moment, I'm doing a POC to see how I can use this product in a SharePoint/Infopath/Workflow project. At the current time, it looks promising.

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-23532755403390223132008-02-05T10:00:00.000-08:002008-02-05T10:02:29.619-08:00Blog post on passing parameters to InfoPath

I found this blog post that talks about passing query string parameters to a broswer InfoPath form. This could be very handy.http://blogs.3sharp.com/Blog/davidg/archive/0001/01/01/1582.aspx

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-61478527621106441732008-02-04T11:40:00.000-08:002008-02-04T11:57:18.132-08:00URL to open a InfoPath form using Forms Server

While working on a InfoPath/SharePoint/Workflow project, we needed to be able to provide a link that would open the IP form in the browser rather than the client. Here is how to form the URL to do just that.http://ServerName/PathToSite/_layouts/FormServer.aspx?XmlLocation=/PathToSite/PathToLibrary/YourFormName.xml&DefaultItemOpen=1The key here is your correct pathing and to include the second

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-88312581623531983142008-02-04T10:34:00.001-08:002008-02-04T10:42:18.864-08:00Great virtual labs

Microsoft Virtual Labs are great because you can try learn, try stuff out, and all for free. Here are some of my favorites.SharePoint Labs:http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032337611&EventCategory=3&culture=en-US&CountryCode=USBuilding InfoPath Forms that run as both Rich Client and Browser Applications Lab:http://msevents.microsoft.com/CUI/

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com0tag:blogger.com,1999:blog-8812962233532740576.post-89922190595734365522008-02-04T10:04:00.000-08:002008-02-04T10:07:37.862-08:00Welcome

This is your typcial welcome post for my blog. Nothing amazing here, so move on.

Lee's Development Bloghttp://www.blogger.com/profile/13321104513126760381noreply@blogger.com