<Frank>
>> From a pure simplistic of connection point of view which would be the
easiest
>> to: set up, work with, transfer data into not using Open Office data
>> transformation tools as they are non existing as yet?
</Frank>
It sounds like you want to have an application that runs on almost anything.
Here's a few possible approaches:
MySQL, Apache and PHP - You create web pages that function as data
entry/query pages. Since they rely only on a browser, you can use Linux,
Windows, Mac or even a PDA. There is some coding involved, but it's not
very hard. You can get a thin $10 book at Barns & Noble that will get you
the basics. Downside - you have to actually write code. Here's a tutorial:
http://www.freewebmasterhelp.com/tutorials/phpmysql
MySQL ODBC driver - Install this in your Windows Boxes (or Mac and Unix
boxes), and you can use any ODBC-aware app to work on your MySQL data. This
does not export the data - it's a live connection to the MySQL server. You
can use Access or Excel (for example) to work on the data. So if the goal
is to provide Win-folks with the ability to get to the data, this works
pretty good. Downside - different apps on different platforms.
http://www.mysql.com/products/connector/odbc/
MySQL ODBC driver + Open Office - If you install Open Office on the Win
boxes, you have a common set of tools on both Windows and Linux. Downside -
little. Here's a "how-to" (PDF):
http://www.unixodbc.org/doc/OOoMySQL9.pdf
Of course, you can do all these things, and have all the benefits. You can
work on Open Office in any machine, the Win user can use Excel to analyze,
and use PHP web pages for query/data entry.
But I'm sure the more experienced will chip in with more refined
suggestions. These may not be as simple as "mysqlcc", but they give you
other abilities, depending on what you are trying to do.
Ken Elliott
=====================
-----Original Message-----
From: slug@nks.net [mailto:slug@nks.net] On Behalf Of SOTL
Sent: Friday, March 11, 2005 5:45 PM
To: Linux SLUG
Subject: [SLUG] Databases
Hi All
As usual I am a bit confused, which goes especially with new ventures and a
database is a new venture.
To my knowledge the best desktop frontend for a simple database is the
database frontend end in Open Office. If there is a better one I would love
to know about it.
Anyway, I desire to locate a data base in a server and connect to it from
eventually 4 computers but at present one.
To translate for those of you who have seen my equipment I would like to put
a database in the MSI box and connect to it with the Thinkpad. Later to add
2 additional computers hopefully from that nasty manufacture located in
Redmont but since I will mot be using one of those computers I am not
overtly concerned about their working or not.
Anyway Open Office provides connection to a number of different types of
data bases including direct connection by URL to Oracle JDBC, MySQL, LDAP,
and JDBC. Open Oddice database will also connect to Adabas D, dBase, & ODBC.
>From a pure simplistic of connection point of view which would be the
easiest
to: set up, work with, transfer data into not using Open Office data
transformation tools as they are non existing as yet?
Would it be best to use dBase and NFT as the only data transformation tool
in Open office is to dBase? Or are there other tools which would make using
one of the other types preferable?
Thanks
Frank
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages posted
are those of the author and do not necessarily reflect the official policy
or position of NKS or any of its employees.
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:35:55 EDT