OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’

Short Description
This article will explain step-by-step how to connect OpenOffice.org 1.0 to the … install OpenOffice.org 1.0, MySQL and MyODBC on MS-Windows - anyone …

Website: www.unixodbc.org | Filesize: 2177kb

Content
OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’
Trademarks are owned by their owners. There is no
warranty about the information in this document. Use and
distribute at your own risk. E&OE. For licence information
please read the appendix.
John McCreesh
jpmcc@users.sf.net Version 09 October 2002Table of Contents
‘Access’ your data - OpenOffice.org 1.0’s best kept secret………………………………………………………………….3
‘Access’ for Linux?……………………………………………………………………………………………………………………………3
Software options……………………………………………………………………………………………………………………………….3
Notes for users of MS-Windows platforms…………………………………………………………………………………………..3
Joining OpenOffice.org 1.0 to MySQL using ODBC…………………………………………………………………………….4
Installing MySQL………………………………………………………………………………………………………………………………4
Testing MySQL…………………………………………………………………………………………………………………………………4
Installing unixODBC and the MySQL libraries……………………………………………………………………………………..5
Creating the ODBC .ini files………………………………………………………………………………………………………………5
Testing ODBC………………………………………………………………………………………………………………………………….6
Setting up ODBC within OpenOffice.org 1.0………………………………………………………………………………………..6
If you use another installation method…………………………………………………………………………………………………8
Using the Data Source Tools in OpenOffice.org 1.0…………………………………………………………………………….9
Finding the Data Source Tools…………………………………………………………………………………………………………..9
Working with Table Definitions…………………………………………………………………………………………………………..9
Creating a table……………………………………………………………………………………………………………………………9
Designing Indexes ………………………………………………………………………………………………………………………9
Changing the definition of a table ………………………………………………………………………………………………..11
Editing data…………………………………………………………………………………………………………………………………….11
Using the Database Toolbar to work with your data…………………………………………………………………………..12
Displaying/Hiding the Data Source Explorer…………………………………………………………………………………12
Find Record……………………………………………………………………………………………………………………………….12
Sort Ascending / Sort Descending……………………………………………………………………………………………….12
AutoFilter…………………………………………………………………………………………………………………………………..12
Default Filter………………………………………………………………………………………………………………………………13
Sort……………………………………………………………………………………………………………………………………………14
Remove Filter / Sort……………………………………………………………………………………………………………………15
Apply Filter………………………………………………………………………………………………………………………………..15
Refresh……………………………………………………………………………………………………………………………………..15
Edit Data……………………………………………………………………………………………………………………………………15
Save Current Record………………………………………………………………………………………………………………….15
Creating new Views of your data………………………………………………………………………………………………………16
Rows in the Query Design…