INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- Turn Off Ad Banners
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...I am very happy with the whole site and would like to extend my compliments to all of you who work to make it one of the most useful sites (If not THE Most Useful) ...and the easiest to navigate..."
Geography
Where in the world do Tek-Tips members come from?
|
 OpenOffice as MySql Client
|
|
|
InnSun (Programmer) |
19 Nov 02 16:18 |
This thread is intended for sharing of experiences with OpenOffice + MySQL. It's a continuation of one first started in the OpenOffice.org forum: Thread904-352533The OpenOffice "Data Sources" function opens up an "Access-like" interface that provides a client to MySQL (or another like database server), thru properly configured ODBCs. A description of what's involved in setup is here: http://www.unixodbc.org/doc/OOoMySQL.pdfSome things I'm interested in: - Hearing from those who have had success with this configuration.
- Knowing if others would like to see changes/additions to this OpenOffice function.
I'm currently testing this on a Red Hat 7.3 system. Thanks  j.ingersoll |
|
a reply to "In the Open Office Data Sources Screen, nearly all of the Access Query functionality is provided for. However, I don't see anyplace to do Relationships (as in the "Tables" Object screen of Ac.)"
If you install the ADABAS database you will see the relationship feature, right click on the word "tables" in the datasource window.
This also shows up with the OCELOT database, however openoffice crashes with OCELOT, as well as with FIREBIRD.
The funcionality is there and shows up with some databases. Why? How? Don´t know.
Cheers,
Peter
|
|
|
InnSun (Programmer) |
5 Feb 03 22:24 |
brotherpeter, Thanks for your reply.
I'm glad to know that relationships has been given some attention, albeit in other database servers.
Isn't ADABAS what primarily makes the difference between OO (free), and StarOffice 6.0 (Commercial)?
Oh well, my friend has a copy of SO 6.0; maybe I can check it out there.
I have never heard of OCELOT & FIREBIRD. But may try them one day.
Regards,
Johnny I. |
|
|
InnSun (Programmer) |
28 Feb 03 7:57 |
Just a general note: Joe Barr has an interesting couple of articles starting here: http://www.linuxworld.com/2003/0207.barr.htmlIn the forum following the article(s) you have some shared experiences documented (and, IMHO, some caustic and unnecessary comments from anonymous  ) regarding adding/modifying in MySQL, I would say first look into GRANTing permissions (probably as root, or whoever owns the application). See e.g., http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#What_Privilegesregarding a windows setup, yes it would be good to hear some experiences from that perspective. But, can I encourage you, why not run Linux? Re-partitioning, setting up Multi-boot, Downloading/instaling a distro is fairly easy today . (all free unless Win2k/XP has all of your hd, in which case Partition Magic is apparently the only way to repartition). |
|
|
 |
|
