MySQL
Support for MySQL Server. Both windows and Linux based systems.
The following versions of MySQL are supported
- MySQL Server 5.0 and 5.1
- MySQL Server 4.0
Additional installation
MySQL requires MyODBC version 3.51.x or Connector/ODBC 5.1 installed on the computer where the RapidiConnector is installed. The RapidiConnector must be installed on a windows computer for now. The MySQL Server can be running under Linux.
The MySQL Server should be set up to use either InnoDB and BDB databases, so that transactions are enabled.
On the MySQL Server you need to grant access to the user:
GRANT ALL ON *.* to “myuser”@”A” IDENTIFIED BY “mypassword”
where “A” is the address of the computer where the RapidiConnector is installed.
Configuration
The fields of the MS-SQL Server Data Source Card are as follows:
- Description: Fill in a descriptive text.
- Server Name/IP: Specify the name of the MySQL Server.
You can also specify the TCP/IP address.
- Database: Specify the name of the database on the MySQL Server.
- UserID: If access to the database requires a UserID you have to specify the UserID here.
- Password: If you enter a UserID the corresponding Password is applied here.
Test and Read Design
