To test the connection to your data source, click Test Connection, input your credentials and click OK. Alternatively, you can specify these parameters in the data source settings of your ODBC Driver for MySQL and leave these fields empty in Database Wizard. If you are connecting to a password protected database, check the Password required field. If your database requires a user name, type it into the User name field.
ODBC Driver for MySQL, or you can click Browse, double-click the data source you need, and then click Next. You can either type the name of your data source into the field, e.g.
Specify the name of the data source you want to connect to. In the Database Wizard dialog box, click Connect to an existing database, select ODBC from the drop-down list, and click Next. Start OpenOffice or LibreOffice, click Database to open the Database Wizard.Īlternatively, you can launch the Database Wizard from OpenOffice or LibreOffice Calc, Writer or any other tool by choosing File > New > Database. To connect to an ODBC data source from OpenOffice or LibreOffice using our driver for MySQL, perform the steps below: To get rid of the error message, set up the 32-bit version of the driver. Note that the Windows version of OpenOffice is 32-bit, and you may get the error “The specified DSN contains an architecture mismatch between the Driver and Application” when trying to access a data source through a 64-bit ODBC driver. You can access MySQL data from Open Office Base or LibreOffice Base - desktop database management systems. The article describes how to use Apache OpenOffice and LibreOffice to access ODBC data sources using the respective driver. 9. Connecting to MySQL from OpenOffice and LibreOffice using ODBC Driver for MySQL Edit the reports (optional)Īdd the company logo provided to the header of each report. In the attached pdf files you can see examples of the reports. The Report must be grouped by City and sorted by Credit Limit. A report that will display customers First Name, Last Name and Credit Limit. This report will have as data source the Active Customers Query A report that will display the active customers. Using the Reports Wizard create two Reports: You can choose any of the predefined layouts. The form must display all fields from Customers table except the ID field. The required query parameters are shown below:Ĭreate a Form named Customers using the Wizard. Open the customers table and enter at least 10 recordsĬreate a query named Active Customers that will display all the active customers. The ID field is the primary key of the Table and must have the AutoValue option to YES. The Field Name and Field Type are listed below This table with hold the customer information. Create the Customers TableĬreate a Table in Design View with the name Customers. Create a new Database and with the name customers-database 2.
0 kommentar(er)
