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:

http://msdn.microsoft.com/en-us/library/windowsazure/hh974312.aspx

Download Microsoft ODBC Driver 11 for SQL Server (windows) here:
http://www.microsoft.com/en-us/download/details.aspx?id=36434

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.