On Thu, Dec 08, Nick Rout wrote:
> surely the first place to go is your distro's packaging system?
Thanks for mentioning it. Certainly easier as distros often supply
the MyODBC drivers on the second disk.
The "OpenOffice1.1-unixODBC-Mysql-Howto" explains the install
and setup procedure for Redhat. Two packages are required,
"UnixODBC" and "MyODBC".
http://www.unixodbc.org/doc/OOoMySQL.pdf
The use of these two packages with OpenOffice is that UnixODBC
is the "driver manager" that interfaces between OpenOffice and
the Mysql drivers called MyODBC.
OpenOffice --> unixODBC --> MyODBC drivers --> mysql database.
|
--> Posgresql drivers --> posgresql
database.
The driver manager can interface with more than one database
if additional drivers (like posgresql db) are added. After
installing the packages run the command 'ODBCConfig' in an
xterm to add the path to the selected drivers.
For mysql /usr/lib/libmyodbc3.so
Check /etc/odbcinst.ini for server,host and password configuration
and /etc/odbc.ini for the driver path. Then start OO's 'sbase"
wizard to log on to the database.
Info that explains further about unixodbc and myodbc configuration
is at.
http://www.unixodbc.org
http://dev.mysql.com/doc/connector/odbc/en/faq_toc.html
--
keith.
