QSqlDatabase ODBC connection to MS SQL Express 2005

In last post I’ve written a recipe how to connect from Linux to Microsoft SQL Server Express using ODBC. Now, since I’m using Qt framework for app portability, it is the time to do the same on Windows.

Read more

Linux ODBC connection to MS SQL on Virtual Box Windows

From some time I was looking for a way to develop MS SQL connected application on Linux. I want to create a bridge between two applications and one of them stores data in Microsoft SQL. Since Kubuntu Linux is my development platform of choice I needed a way to be able to connect to the database from my system.

There are several obstacles to overcome, of which the most annoying is that you can’t put MS SQL on Linux directly. There might be a dozen solutions to this (like having an additional Windows/MS SQL server) I prefer to keep all the needed things on my dev box.

Since I have Windows 7 RC downloaded and there’s a free download of Microsoft SQL Server Express 2005 I decided to put Virtual Box to hard work for me.

Read more…