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 …. You now need to tell OpenOffice.org 1.0 about your ODBC connection. …

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

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 17 April 2003Table 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……………………………………………………………………………………………………………………………5
Installing unixODBC ……………………………………………………………………………………………………………………5
Creating the ODBC .ini files…………………………………………………………………………………………………………..6
Testing ODBC……………………………………………………………………………………………………………………………..6
Setting up ODBC within OpenOffice.org 1.0……………………………………………………………………………………7
If you use an earlier version of RedHat / 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…