MSSQL Access under Linux

[Bill Campbell]

On Mon, Mar 26, 2007, Matthew Carpenter wrote:

>Doesn't OOo or some other project actually have a MSAccess-equivalent for 
>MySQL?

There are a variety of database connectors for OpenOffice.org.
Generally speaking I've found the JDBC connectors the least
trouble and most reliable (which makes sensce given the Sun/Java
heritage of OO.org).  Install the approprate JAR files, Add them
to OO.org's CLASSPATH, figure out the magic incantations under
File->New->Database to connect to the database, and things work
well.

Using the MySQL connector the parameters are:

URL     mysql://hostname/database
driver  com.mysql.jdbc.Driver

Being that M$SQL is a Microsoft product, I suspect that it works
best using ODBC.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

Anyone who cannot cope with mathematics is not fully human.  At best he
is a tolerable subhuman who has learned to wear shoes, bathe and not
make messes in the house.
        -- Lazarus Long, "Time Enough for Love"