Configuring and Using Databases

From NeoWiki

Revision as of 04:56, 8 December 2005 (edit) Sardisson (Talk | contribs) (beginnings of database rewrite) ← Previous diff		Revision as of 08:44, 8 December 2005 (edit) (undo) Sardisson (Talk | contribs) (add 1st draft at real text for this page) Next diff →
Line 1:		Line 1:
	{{handbook sidebar|DatabaseTOC}}		{{handbook sidebar|DatabaseTOC}}
-	NeoOffice and databases are really cool	+	While [[NeoOffice|NeoOffice 1.2 Alpha]], NeoOffice/J 1.1 and [[OpenOffice.org Mac OS X (X11)|OpenOffice.org/X11 1.1.x]] do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports.
		+
		+	If you do not have a MySQL or hsqldb database, you can also create a simple database in NeoOffice or OpenOffice.org/X11—or even use a Calc table if your needs are very simple.
		+
		+	The various pages of this article contain information on installing, configuring, and using a these databases with NeoOffice or OpenOffice.org/X11.
		+
		+	''Maybe insert a screenshot here to balance the length of the page vs. the length of the TOC--the TOC will get shorter when the articles are done, but storing comments there now until we decide on page names, etc.''
	[[Category:Tips and Hints]][[Category:NeoOffice/J]][[Category:OpenOffice.org]][[Category:Fixme]]		[[Category:Tips and Hints]][[Category:NeoOffice/J]][[Category:OpenOffice.org]][[Category:Fixme]]

---

Revision as of 08:44, 8 December 2005

Introduction to NeoBase Configuring MySQL using ODBC and Mac App Store versions of NeoOffice Configuring MySQL using JDBC and NeoOffice 2.x Configuring MySQL using ODBC Configuring hsqldb Configuring postgresql Configuring FileMaker Pro Working with dBase databases Using a Calc spreadsheet as a data source Using your database with NeoOffice

While NeoOffice 1.2 Alpha, NeoOffice/J 1.1 and OpenOffice.org/X11 1.1.x do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports.

If you do not have a MySQL or hsqldb database, you can also create a simple database in NeoOffice or OpenOffice.org/X11—or even use a Calc table if your needs are very simple.

The various pages of this article contain information on installing, configuring, and using a these databases with NeoOffice or OpenOffice.org/X11.

Maybe insert a screenshot here to balance the length of the page vs. the length of the TOC--the TOC will get shorter when the articles are done, but storing comments there now until we decide on page names, etc.