Welcome to MSDN Blogs Sign in | Join | Help

February 2009 - Posts

Friday, February 27, 2009 2:40 PM

(working) TCP network monitor trace explained.

Today I’ll do something different, I will describe something that works. In this case, how to understand a network trace for an TCP/IP connection Basically this is a short description on how a TCP/IP connection works when connecting to SQL Server. Note
Posted by maspeng | 0 Comments
Friday, February 27, 2009 12:44 PM

System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

This error gets reported every now and then and this is my try to explain what is going on. The scenario: You have written a .Net app that connects and interacts with Access 2007. When you move it to an x64 machine, it stops working with the following
Posted by maspeng | 1 Comments
Friday, February 06, 2009 2:49 PM

Getting "Query is too complex" or "Expression is too complex” when using Access

The scenario, you have an MS Access database and you want to run queries against it. A fairly common thing to want to do J However, now you are getting the following exception, assuming you are running a .Net application: System.Data.OleDb.OleDbException:
Posted by maspeng | 0 Comments
Filed under: ,
Thursday, February 05, 2009 4:21 PM

Typed DataSet from xsd using LINQ. Trial by fire

If you are on this particular page, then the question you might be asking your self is this: How come that when I try to query a typed dataset that is created by using the xsd.exe tool via LINQ, I’ll get a compilation error along the lines of: 'ColumnName'
Posted by maspeng | 1 Comments
 
Page view tracker