EricZander.com
 
Publications     Connecting OpenOffice.org To A Remote MySQL Database

 

Tutorial

1 Download and install the MySQL ODBC driver from http://www.mysql.com/downloads/api-myodbc.html
2 Download and install OpenOffice.org from http://www.openoffice.org
3 Once installed, load up a blank OpenOffice.org document. I always use a text document but you can also use a spreadsheet document or HTML document.
4

To begin connecting, select "Data Sources..." from the "Tools" pull-down menu to pull up the "Data Source Administration" window.

The "Tools" pull down menu with "Data Sources..." highlighted

The "Data Source Administration" window

 

5

Click on the "New Data Source" button in the upper let corner of the of the Data Source Administration window.

6

You'll want to give your new data source a name and then change the "Database Type" to MySQL. Note that the tabs offered will change with the data type.

7

Select the "MySQL" tab and enter in the remote database information. To begin, click the "..." button to the right of the "Data Source URL" text field.

The "Data Source Administration" window with the MySQL tab in the forefront

The "..." button highlighted

8 Clicking the "..." button will pull up the "Data Source" window which is actually part of the MySQL ODBC driver configuration.

9

In the lower right hand corner of the "Data Source" window, click on the "Organize" button to pull up the "ODBC Data Source Administrator" screen.

The "Organize" button

The "ODBC Data Source Administrator" screen

10

Click the "Add..." button on the right hand side of the window to add a new data source to the list. This will pull up the "Create New Data Source" wizard.

The "Add..." button

The "Create New Data Source" wizard screen

 

11

In the first step of the create new data source wizard, scroll down to the bottom of the list of drivers to find the MySQL ODBC driver. Select the driver and click "Finish"

The ""Create New Data Source" wizard with the MySQL ODBC driver selected

The "Finish" button (yes, I am getting a little carried away here...)

 

12

After clicking the "Finish" button in step 12, the "MySQL ODBC Driver DSN Configuration" window will be presented. This is where all the important information is entered.

13
  • You need to enter a descriptive name for your new connection in the "Data Source Name" text field.
  • In the "Host/Server Name (or IP) field" enter the host name (i.e. myserver.com) or IP number of your server (i.e. 123.45.678.90).
  • The "Database Name" field is the name exactly as it is named on the remote server. I learned the hard way this is case sensitive.
  • "User" is the remote database user account with privileges to log into this database.
  • "Password" is the case sensitive password the user needs to access the remote database.
  • You probably don't have to worry about the port number or "SQL command on connect"
14

Once you have entered all of the information, click on the "Test Data Source" button to verify you entered the information correctly and a connection can be made.

The "Test Data Source" button
The successful connection pop-up window
15 Once you have successfully made a connection you now need to get back out to the original "Data Source Administration" window. Click "OK" to exit the "MySQL ODBC Driver DSN Configuration" window. This will return you to the "ODBC Data Source Administrator" screen with the new data source added to the list.
16

Nothing here to do except click "OK" to be returned to the "Data Source" window. Select your data source and click "OK" to return to the "Data Source Administration" window. Now you can run queries, add/delete records and more using the "Tables," "Queries," and "Links" tabs. There's a nice Access-like query builder or you can enter SQL statements directly if you want.

17 That's all there is to it!

<<Previous   1   2   3   4   5   Next>>

 

Other Stuff
Contact Us

 

OO.org/MySQL Tutorial
1 Introduction
2 Background
3 Tutorial
4 Summary
5 References & Links