Difference between revisions of "MySQL"

From RadiWiki
Jump to: navigation, search
(Configuration)
Line 7: Line 7:
  
 
== Configuration ==
 
== Configuration ==
A detailed description of the configuration of an ODBC connection to a [[Customer database]] is explained on the [[ODBC Customer database]] page.
+
A detailed description of the configuration of an ODBC connection to a [[Customer database]] is explained on the [[ODBC Customer database]] page. However some MySQL specific ODBC connection parameters are needed, which are:
 +
* server name
 +
* server connection port (by default: 3309)
 +
* username
 +
* password
 +
* database name
 +
Your MySQL database administrator will be able to provide you with the correct details.
  
 
== Links ==
 
== Links ==

Revision as of 10:46, 25 November 2010

A MySQL database can be used as a Customer database in RadiMation®. Using your company MySQL database, will simplify the selection of the customer address information into the RadiMation® EUT window.

We have tested this functionality with a MySQL version 5.0 (5.0.51b to be exact) Community server. Any newer version of the MySQL server should not give any problems.

Requirements

To enable the communication between RadiMation and the MySQL database, it is necessary that the MySQL Connector/ODBC is installed. We advise you to install the version 5.1 or higher of the MySQL Connector/ODBC. The MySQL Connector software package can be downloaded from the MySQL website (see the links below).

Configuration

A detailed description of the configuration of an ODBC connection to a Customer database is explained on the ODBC Customer database page. However some MySQL specific ODBC connection parameters are needed, which are:

  • server name
  • server connection port (by default: 3309)
  • username
  • password
  • database name

Your MySQL database administrator will be able to provide you with the correct details.

Links