Getting error "The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine"

PROBLEM DESCRIPTION:   While I was trying to connect to an Access Database from Visual Studio 2010 on my Windows 7 x64 server, I got the following error message,   Server Error in ‘/myCalendar’ Application. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. Description: An unhandled exception occurred during the execution of the…


Did you know? How to connect to Microsoft Access database from a .NET 4.0 application

Goal: To write a SQL command that will connect to the Microsoft Access 2010 database in Visual Studio 2010.   Solution: This can be achieved using the connection string as follows,   OleDbConnection connection = new OleDbConnection(“Provider=Microsoft.ACE.OLEDB.12.0; Data source=D:\\Database\\myDatabase.accdb; Persist Security Info = False”);   I hope this helps.


Did you know? To use the SQL select command based on a value selected from a dropdown list

Background: I was looking for a requirement where I needed to use the SQL SELECT command based on a user’s input. In my case, it was a selection made from a DropDownList. This select command will be further used to populate a GridView. The HTML code is as follows, <asp:DropDownList ID=” DropDownList1“ runat=”server”> <asp:ListItem Selected=”True”>Select…


Breaking Changes in Visual Studio 2010

Visual Studio 2010 was released by Microsoft yesterday (12th April 2010). VS 2010 promises a lot of new features. More details of the new features are present in the following articles, What’s New in the .NET Framework 4 What’s New in Visual Studio 2010 What’s New in Visual C# 2010  Security Changes…


Visual Studio IDE hung while switching from Source View to Design View

PROBLEM DESCRIPTION: While switching between the design view and the source view in Visual Studio, it was observed that the switching takes around 2-3 minutes to complete. During this while, the IDE was in a hung state. RESEARCH: 1.    We suggested the customer to use DebugDiag and collect a hang dump. 2.    I used the…


Getting error "IIS is not installed or is disabled" during SQL Reporting Services installation

PROBLEM DESCRIPTION: One of my customers was trying to install SQL Reporting Services and noticed that he was not able to complete the installation. The IIS feature was disabled during the installation, and it was giving the following error message, Unable to complete installation as IIS is not installed or is disabled.   FINDINGS: –         …


Unable to connect to Remote Desktop Web Connection (TSWeb)

PROBLEM DESCRIPTION: My customer was facing issue while installing the Remote Desktop Web Connection ActiveX control on Windows XP SP2. TROUBLESHOOTING DONE: –      He was using Windows XP SP2 and had installed the Remote Desktop Web Connection : XPSP2 [5,1,2600,2180] from –      But we somehow weren’t able to run the TSWeb even after we followed…