Shawn Weisfeld

I find when I talk to myself nobody listens. - Shawn Weisfeld
posts - 365, comments - 174, trackbacks - 34

My Links

News


Shawn Weisfeld's Facebook profile

The views expressed in this blog are mine and mine alone, not that of my employer, Microsoft, or anyone else’s. No warrantee is given for the quality of any material on this site.

Archives

Post Categories

July 2009 Entries

Debugging with Windows VISTA and Visual Studio 2005

Problem: “Unable to attach to the process. The system cannot find the file specified.” OR “Unable to start debugging on the web server. Attaching to a process in a different terminal server session is not supported on this computer. Try remote debugging to the machine and running the Microsoft Visual Studio Remote Debugging Monitor in the process’s session.” Fix: Check your Local Security Policy, you need to ensure that Administrators have "Debug Programs" permission (Security Settings | Local Policies | User Rights Assignment)

posted @ Tuesday, July 21, 2009 1:22 AM | Feedback (2) | Filed Under [ Visual Studio 2005 ]

SAP .NET Connector Password Error

It appears from some testing that one of the libraries that ships with the SAP .NET Connector doesn’t support hardened passwords. You might get the following error: “Name or password is incorrect (repeat logon)” To correct the problem you need to put the latest version of the librfc32.dll into the bin folder of your .NET Application. If you have the SAP client installed on your desktop you will find this dll in the c:\windows\system32\ folder.

posted @ Tuesday, July 21, 2009 1:20 AM | Feedback (1) | Filed Under [ SAP ]

Call a Multiple-Rowset stored procedure with LINQ to SQL and without the designer

Multiple-Rowset allows you to return more than one select from your stored procedure. For example in the stored procedure below you can see we have 2 select statements. As we learned in my last 2 posts it is possible to use LINQ to SQL without the designer. A simple select with LINQ to SQL and without the designer (http://drowningintechnicaldebt.com/blogs/shawnweisfeld/archive/2009/07/11/a-simple-select-with-linq-to-sql-and-without-the-designer.aspx) Call a stored procedure with LINQ to SQL and without the designer (http://drowningintechnicaldebt.com/blogs/shawnweisfeld/archive/2009/07/11/call-a-stored-procedure-with-linq-to-sql-and-without-the-designer.aspx) To utilize Multiple-Rowset we just need to tweak our function in our data context...

posted @ Sunday, July 12, 2009 4:45 PM | Feedback (0) | Filed Under [ C# LINQ to SQL ]

Call a stored procedure with LINQ to SQL and without the designer

In my last post I talked about how to do a simple select with LINQ to SQL without the designer (http://drowningintechnicaldebt.com/blogs/shawnweisfeld/archive/2009/07/11/a-simple-select-with-linq-to-sql-and-without-the-designer.aspx). This is all well and good, but what if you need to use a stored procedure. Like this one. . . . The first step is to add to our data context a method that maps to our stored procedure. You can see we start off with a Function attribute that tells LINQ to SQL what stored procedure to use. Additionally we decorate the parameters on our method with Parameter attributes that tell LINQ to SQL how to...

posted @ Saturday, July 11, 2009 10:15 PM | Feedback (3) | Filed Under [ C# LINQ to SQL ]

A simple select with LINQ to SQL and without the designer

Many folks poo-poo LINQ to SQL because they don’t like designers. On the other hand some developers, myself included, like knowing how things work behind the scenes, for those edge case moments when the designer cannot do something. The most common business case for this is if you want to LINQ to SQL-afy an existing suite of objects. Well using the designers is NOT a requirement of LINQ to SQL. Lets say for example you had an existing customer table and customer business object: Lets see if we can get LINQ to SQL to...

posted @ Saturday, July 11, 2009 9:57 PM | Feedback (2) | Filed Under [ C# LINQ to SQL ]

Could not open a connection to SQL Server

Problem: .NET application throws the following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Solution: Check SQL Server to ensure that TCP/IP is enabled. Open the List of available “Protocols for SQL Server”. You can find this in the “Computer Management” Console under “Services...

posted @ Wednesday, July 8, 2009 11:44 AM | Feedback (1) | Filed Under [ SQL ]

Save the MIS Program at UCF

I got the email below and it broke my heart, they are trying to shutdown the MIS program at UCF. If you are an MIS alumni from UCF please read below and take action to help save MIS at UCF. ----------------------------------------------------------------------------------------- Send reply's Email Dr. West (lwest@bus.ucf.edu) I am writing to alumni of the UCF MIS program to ask your help with a pretty serious matter.  You may or may not have heard that UCF has announced the elimination of five academic programs and the termination of the associated faculty because of...

posted @ Wednesday, July 8, 2009 11:40 AM | Feedback (0) | Filed Under [ UCF ]

Using ROW_NUMBER() to eliminate the multiplicative effects of a join

Problem: It is a common situation to have a header/detail tables in SQL Server. Additionally sometimes you include a calculated value on the header table to make reporting easier. For Example lets say you had an SalesPerson table that had a column for total sales. Now you also have a SalesDetails table that lists every sale that the company made. The purpose of having the total sales column is that it eliminates the need to touch the larger SalesDetails table when you just need to get the total by sales person. This is a good thing until the user...

posted @ Friday, July 3, 2009 12:33 PM | Feedback (6) | Filed Under [ SQL ]

Powered by: