MySQL with open connection ODBC and JDBC

OpenOffice.org 2 Base & MySQL with JDBC

Download, Intallation, & Configuration
1. Download OpenOffice.org2, MySQL4, JRE, and mysql-connector-java-3.1.10-bin.jar (or last release)
2. Instal OOo, MySQL, and JRE
3. Open OOo then go to Tools > Options > Java
3a. Klik Add and insert file JRE
4. Click Class Path button
5. Click Add Archive button
6. Insert file mysql-connector-java-3.1.10-bin.jar and mysql-connector-java-3.1.10-bin-g.jar
(see Help OOo2 Base: Java>JDBC)

Use
1. Open OOo2 Base
2. Choose Radio Buttin Connect to an existing database
3. Select MySQL for Database type then Next
4. Choose Connect using JDBC then Next
5. Insert existing MySQL database name, Server URL (usually: localhost), and Port Number (usually: 3306), then Next
6. Insert username of MySQL Database and check password required if the username using password
7. Finish

Info
1. When u edit the MySQL database, if u open the database at MySQL command line, it will change too. And so on.
2. The advantage of using JDBC then ODBC is more simple. U can select the database when you open connection to MySQL.

***

MySQL with ODBC

Download and istall myODBC (?)

1. Buka Data source at Control Panel > Administrative Tools > Data Sources (ODBC)
2. Pada tab User DNS, klik Add. Lalu pilih driver mySQL ODBC 3.51 Driver > FInish
3. Pada jendela Conector/ODBC Isi form entry dg benar. Lalu OK
4. Maka pada ODBC Data Source Administrator, tab user DNS, user data sources baru akan ditambahkan.

Dari sini Anda bisa mengakses pake Access or OOo Base

 

 

 

Send instant messages to your online friends http://uk.messenger.yahoo.com