Friday, August 9, 2013

SQL Azure- Open source access

In my 2011 book, I have described the procedure for connecting to SQL Azure using OpenOffice Version 3.2.1. Basically OpenOffice supports this connectivity using ODBC. Follow this link:

Download Microsoft ODBC Driver 11 for SQL Server (windows) here:

This should let you create an ODBC connection which allows connection to SQL Servers.

Once you have this you can follow the procedure in "Microsoft SQL Azure: Enterprise Application Development,2011, ISBN:978-1-849680-80-6, Chapter 10: Recent Developments #OpenOffice access to SQL Azure"

Please note that I have not tested this with new version of Apache OpenOffice and the new ODBC driver.

The above example shows running reports using SQL Azure Data.

Get the March 2018 Power BI update

The update is out and you can get it from here : You can also get it from Windows Store if you are running Windows 10. Well what is n...