Openoffice.org with SQL Databases - Revision history

⚠️Jorah: /* Installation of PostgreSQL driver (MacOSX) */

2015-09-14T09:07:29Z

Installation of PostgreSQL driver (MacOSX)

← Older revision		Revision as of 09:07, 14 September 2015
Line 38:		Line 38:
	Please use the [http://jdbc.postgresql.org/download.html JDBC driver].		Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

	There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver. But there is unofficial ~~PosgreSQL ODBC driver for MAC OS X~~ https://www.devart.com/odbc/postgresql/download.html		There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver. But there is unofficial [https://www.devart.com/odbc/postgresql/download.html PosgreSQL ODBC driver] for MAC OS X which you can download for free.

	<br>		<br>

⚠️Jorah: /* Installation of PostgreSQL driver (MacOSX) */

2015-09-14T09:05:09Z

Installation of PostgreSQL driver (MacOSX)

← Older revision		Revision as of 09:05, 14 September 2015
Line 38:		Line 38:
	Please use the [http://jdbc.postgresql.org/download.html JDBC driver].		Please use the [http://jdbc.postgresql.org/download.html JDBC driver].

	There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver.		There are not mac OSX version of official SDBC driver, you can connect your postgreSQL database using the JDBC driver. But there is unofficial PosgreSQL ODBC driver for MAC OS X https://www.devart.com/odbc/postgresql/download.html

	<br>		<br>

⚠️Jorah: /* SQLite files (OpenOffice.org 2.x) */

2015-09-14T09:00:34Z

SQLite files (OpenOffice.org 2.x)

← Older revision		Revision as of 09:00, 14 September 2015
Line 204:		Line 204:

	* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>		* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>
	* Tested and working [https://www.devart.com/odbc/sqlite SQLite ODBC driver]. Connection string and installation guide of SQLite ODBC driver [https://www.devart.com/odbc/sqlite/docs/using_odbc_driver.htm]		* Tested and working [https://www.devart.com/odbc/sqlite SQLite ODBC driver]. Connection string and installation guide of SQLite ODBC driver https://www.devart.com/odbc/sqlite/docs/using_odbc_driver.htm
	* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:		* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:

⚠️Jorah: /* SQLite files (OpenOffice.org 2.x) */

2015-09-14T09:00:03Z

SQLite files (OpenOffice.org 2.x)

← Older revision		Revision as of 09:00, 14 September 2015
Line 204:		Line 204:

	* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>		* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>
	* Tested and working [https://www.devart.com/odbc/sqlite SQLite ODBC driver]. [https://www.devart.com/odbc/sqlite/docs/using_odbc_driver.htm ~~SQLite ODBC driver connection string~~] ~~and installation guide.~~		* Tested and working [https://www.devart.com/odbc/sqlite SQLite ODBC driver]. Connection string and installation guide of SQLite ODBC driver [https://www.devart.com/odbc/sqlite/docs/using_odbc_driver.htm]
	* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:		* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:

⚠️Jorah: /* SQLite files (OpenOffice.org 2.x) */

2015-09-14T08:58:05Z

SQLite files (OpenOffice.org 2.x)

← Older revision		Revision as of 08:58, 14 September 2015
Line 204:		Line 204:

	* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>		* <strike>[http://dba.openoffice.org/drivers/sqlite/index.html OO-Base SQLite driver] (driver still in alpha state)</strike>
			* Tested and working [https://www.devart.com/odbc/sqlite SQLite ODBC driver]. [https://www.devart.com/odbc/sqlite/docs/using_odbc_driver.htm SQLite ODBC driver connection string] and installation guide.
	* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:		* [http://www.ch-werner.de/sqliteodbc/ SQLite ODBC Driver] (wrapped SQLite library into an ODBC driver). Installation:

⚠️Jorah: /* MySQL (OpenOffice.org 2.x) */

2015-09-14T08:49:12Z

MySQL (OpenOffice.org 2.x)

← Older revision		Revision as of 08:49, 14 September 2015
Line 174:		Line 174:

	* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html		* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html
			* Connection via [https://www.devart.com/odbc/mysql/docs/using_odbc_driver.htm MySQL ODBC driver]

	=== DBF files (OpenOffice.org 2.x) ===		=== DBF files (OpenOffice.org 2.x) ===

⚠️Jorah: /* Usage of OpenOffice-Base with various drivers */

2015-09-14T08:45:03Z

Usage of OpenOffice-Base with various drivers

← Older revision		Revision as of 08:45, 14 September 2015
Line 3:		Line 3:
	== Usage of OpenOffice-Base with various drivers ==		== Usage of OpenOffice-Base with various drivers ==

	* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.		* See [http://dba.openoffice.org/drivers/index.html Database drivers] page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files. Also you can check an expanded list of [https://www.devart.com/odbc/ ODBC drivers] for Oracle, SQL Server, PostgreSQL, MySQL, SQLite.

	=== PostgreSQL (LibreOffice.org 3.x) ===		=== PostgreSQL (LibreOffice.org 3.x) ===
Line 9:		Line 9:
	The version LibreOffice 3.5 introduces a new PostgreSQL driver:		The version LibreOffice 3.5 introduces a new PostgreSQL driver:
	http://www.libreoffice.org/download/3-5-new-features-and-fixes/		http://www.libreoffice.org/download/3-5-new-features-and-fixes/
			Alternative [https://www.devart.com/odbc/postgresql/ PostgreSQL ODBC driver] perfectly works with the latest LibreOffice.

	=== PostgreSQL (OpenOffice.org 2.x) ===		=== PostgreSQL (OpenOffice.org 2.x) ===

⚠️Madi at 09:36, 23 April 2015

2015-04-23T09:36:09Z

← Older revision		Revision as of 09:36, 23 April 2015
Line 168:		Line 168:

	[[Category: FAQ]]		[[Category: FAQ]]
			[[Category:database]]

	=== MySQL (OpenOffice.org 2.x) ===		=== MySQL (OpenOffice.org 2.x) ===

Neteler: Reverted edits by Domtheo (talk) to last revision by Neteler

2013-09-25T16:25:04Z

Reverted edits by Domtheo (talk) to last revision by Neteler

← Older revision		Revision as of 16:25, 25 September 2013
Line 26:		Line 26:

	* Connect to existing database (select driver): postgresql		* Connect to existing database (select driver): postgresql
	* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the		* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
	[http://www.optimaweb.co.id/jasa-seo Jasa seo], [http://www.optimaweb.co.id/jasa-seo Jasa seo Beragaransi], [http://www.propertykita.com/rumah.html Rumah Dijual di Depok], [http://www.grosir-kosmetik.com/6-baby-pink-cream-pemutih-kulit Baby Pink Asli] database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
	dbname=pgtest host=my.databaseserver.org		dbname=pgtest host=my.databaseserver.org
	* User name (the login name): yourname		* User name (the login name): yourname

⚠️Domtheo: minor edit

2013-09-24T03:23:42Z

minor edit

← Older revision		Revision as of 03:23, 24 September 2013
Line 26:		Line 26:

	* Connect to existing database (select driver): postgresql		* Connect to existing database (select driver): postgresql
	* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:		* Connection settings: We have to define the server ("host") name and the name of the database, probably also the user name in case you have to connect with a different user name. To find out, '''ask your DB administrator''' or use in a terminal "psql -l " or, if the
			[http://www.optimaweb.co.id/jasa-seo Jasa seo], [http://www.optimaweb.co.id/jasa-seo Jasa seo Beragaransi], [http://www.propertykita.com/rumah.html Rumah Dijual di Depok], [http://www.grosir-kosmetik.com/6-baby-pink-cream-pemutih-kulit Baby Pink Asli] database is on a remote server, "psql -h host.mydomain.org -l". An entry may look like this:
	dbname=pgtest host=my.databaseserver.org		dbname=pgtest host=my.databaseserver.org
	* User name (the login name): yourname		* User name (the login name): yourname