Missing SQL Server dll: Microsoft.SqlServer.Types

Recently with a number of .net Click Once projects we have been hitting errors on installing with Missing SQL Server dll: Microsoft.SqlServer.Types These have been where projects use Microsoft Report Viewer, a component I try and avoid these days because it gives more install problems than anything else. These have been the steps to resolve the [...]

By | 2017-02-17T11:45:11+00:00 February 17th, 2017|Uncategorized, Visual Studio|0 Comments

Cycle Clipboard Ring

ctrl+shift+v In SQL Management Studio 2016 sp1 and Visual Studio 2015 update 3, this will cycle the clipboard ring, for the last 20 items. Its not necessary to jump back and forth copying and pasting, you can copy all the items you need one after another, then paste them using ctrl+shift+v to cycle through the [...]

By | 2017-01-16T16:16:30+00:00 January 16th, 2017|Uncategorized|0 Comments

SQL CREATE OR ALTER stored procedure

We have upgraded to the 2016 Service Pack 1 version of SQL Server. Microsoft are keeping the server based and Azure based versions much more in synch than they used to so it was no surprise to find a new feature in regular MS SQL available in Azure too. When creating stored procedures in t-sql, [...]

By | 2017-01-16T16:07:49+00:00 January 16th, 2017|Uncategorized|0 Comments

SQL Import Wizard Error Importing Excel Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

  Symptoms Using SQL Server 2014 import tool from within the Management Studio to import an Excel spreadsheet this error message appears: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) The spreadsheet opens fine on the machine using Excel Solution Microsoft Office 64bit Version is installed, but the management studio is 32bit [...]

By | 2015-08-05T15:35:19+00:00 August 5th, 2015|Recent Posts, Uncategorized|0 Comments

Janus CalendarCombo box quirk

As I was working on a new system I encountered problems with the calendar combo field. The date would seeming randomly not fill correctly while other times it would fill fine. I checked to see if it was a problem with certain records or problems in my code but there wasn't, the calendar could fill [...]

By | 2015-04-27T11:23:39+00:00 April 27th, 2015|Recent Posts, Uncategorized|0 Comments

Microsoft Office Automation and .Net

For 15 years I have been using the Office object model, within classic VB and then with .Net. Its never an easy area to write for having to watch for memory leaks, and navigating the complex object model of Word, Excel and Outlook. Another problem, is that of office versions. Now that office has been [...]

By | 2015-04-23T08:44:28+00:00 April 23rd, 2015|Recent Posts, Uncategorized|0 Comments

Visual Studio and Crystal Reports

Back in the mid 90s Crystal Reports was included as part of the Visual Basic Development package. Then it got dropped for a version. Since Visual Studio its releationship with Microsoft's products has been equally fluid. Crystal Reports over the years has given us more problems with deployment that everything else we combined. It was [...]

By | 2015-04-16T11:18:11+00:00 April 16th, 2015|Recent Posts, Uncategorized|0 Comments

Visual Studio Community 2013

For non-enterprise organisations with up to 5 users, Microsoft has now announced the new edition of Visual Studio Express, named Visual Studio Community will be available free of charge. This removes the limitations of the previous express versions. Looking forward to testing this out at Kandy Solutions. Up to now, the premium add-ons we use to [...]

By | 2015-01-15T15:51:56+00:00 January 15th, 2015|Uncategorized|0 Comments

Running an application outside the debugger

In visual studio, if you search in the bin folder, you can find the .exe of your application and run it directly. An easier way is to press ctrl+F5 in Visual Studio, this will run the application without debugging. You won't be able to stop it in Visual Studio, or to debug, but its a [...]

By | 2015-01-14T15:11:15+00:00 January 14th, 2015|Uncategorized|0 Comments