July 2009 Entries
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)
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.
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...
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...
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...
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...
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...
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...