qODBC Fails to Launch QuickBooks

I recently ran into an interesting issue where the qODBC bridge we use to connect to QuickBooks from our custom application would fail to properly initialize QuickBooks. In principal the qODBC bridge is an ODBC driver that connects to QuickBooks via QuickBooks's API by launching an instance of the actual QB GUI and then communicating that way with it. It follows that our custom application connects in turn to qODBC to perform database related calls to QuickBooks.

Recently after a server patching we started receiving these error messages when trying to connect to QuickBooks:

Unhandled Exception: System.Exception: Cannot connect to QuickBooks: ERROR [00000] [QODBC] QB Begin Session Failed. Error = >80040408, Could not start QuickBooks. ERROR [00000] [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. ---> System.Data.Odbc.OdbcException: ERROR [00000] [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.

Full Article

Car Review - Mini Cooper JCW 2016

Make/Model: MINI Cooper John Cooper Works 2016
Colour: Rebel green with red roof
New?: Demo, had 656km on the clock
Engine: 2.0l Turbocharged
Power/Torque: 170kW (228 BHP) / 320Nm (236 ft/lb)
Average Fuel Consumption: 5 - 7.5 l/100 km (Highway - City)
Performance: 0-100km/h in 6.1s, 247 km/h top speed
Owned: Jan 2016 - Mar 2018

Notes:
Pardon the dirt - these are the only pictures I have.

For a review, see the new 2018 JCW. The two cars are basically identical for all practical purposes and most comments apply the same.

Full Article

Fix Microsoft SQL Server User Login Bindings

If you ever tried to backup / restore a Microsoft SQL Server database from one server to another, or one database instance to another, you might have run into the issue where the database security user account has been restored but it does not have a corresponding instance login account, or, the instance login account is present but it is not linked to it. You may be tempted to open up the instance login account and assign it to the database and database user account, but you will receive an error:

User, group, or role 'XXX' already exists in the current database (Microsoft SQL Server, Error: 15023)

The fix is simple - run this from an SQL window:

Full Article

How to connect to Microsoft LocalDB

Sometimes you need to connect to an instance of SQL LocalDB and all you have to go on is the ConnectionString that looks like this:

Server=(localdb)\mssqllocaldb;Database=aspnet5...

Trying to use SQL Server Management Studio to connect to (localdb)\mssqllocaldb would most likely fail. Instead, run the command:

Full Article

Apple TV 4 and Dolby Digital Woes

The new Apple TV 4 does not have an optical out any longer, meaning all audio has to pass via the HDMI interface. When I replaced my Apple TV 3 with the new version, I found that my surround sound receiver did not play back any DTS or Dolby Digital soundtracks in any of my encoded movies, or Apple TV rented / purchased movies. My Yamaha amp kept on showing PCM mode (HDMI is connected between Apple TV and receiver, the receiver then passes this on to the monitor as a final output of video only) . For all my encoded movies it was restricted to 2 channel stereo, the Apple TV based movies were 5.1 channel PCM.

The fix was to go to Settings -> Audio Settings -> Surround Sound mode to Dolby Surround. This may or may not work for you depending on a thousand factors.