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.
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.
No comments:
Post a Comment