Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different flavors of SQL.

What I'm significantly hazier on is this: Is there a way for me to use MySQL syntax within LibreOffice or OpenOffice? If so, would someone be able to describe it or link me to some docs? (I may just be using the wrong google queries.)

Whether you have an answer or not, thanks for your time in reading.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

Make sure you download the correct 32 or 64 bit version depending on your version of libreoffice.

http://dev.mysql.com/downloads/connector/odbc/5.2.html#downloads install the odbc connector

control panel admin tools ODBC

User DSN Add Mysql ODBC......

New dialog dsn: whatever tcp/ip:

fill in the rest of the credentials Click test and make sure everything is OK.

when I launch libre office base 4.0.3 I get a database wizard What do you want to do?

Connect to an exiting database: select ODBC Browse select the ODBC you created above. connect using ODBC

username (again) check password if required

Finish Save name it whatever you want.

login again and your done

share|improve this answer
    
This definitely sets up the connection. I haven't tested the actual syntax yet, but since nobody else is answering, I'm definitely going to mark this as the accepted answer, since I really appreciate the time you took to submit detailed steps. In case you feel like going above and beyond: Do you know of any MySQL-specific query language I could use to test the syntax side of this -- something that wouldn't work in other versions of SQL? –  HamComa Jun 24 '13 at 21:08
    
@user49982 Either you will be able to access it or not. select * from <tablename> should result in data. Unfortunately the statement is generic SQL, but it is still effective. The table exists on the server not inside of LibreOffice. If LibreOffice Base can see the data your in. –  cybernard Jun 27 '13 at 15:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.