Top

5.1.10.MySQL

Datasource

Figure5.68.Datasource tab

Datasource tab

MySQL Options

Figure5.69.MySQL Options tab

MySQL Options tab

  • Hostname. The hostname on which the MySQL database server to be connected to is running on.

  • Port. The port number on which the MySQL database server is running on the host machine. Defaults to 3306 if not specified.

  • Database. The database name to which the connection is to be made.

MySQL Options

Figure5.70.MySQL Options tab

MySQL Options tab

  • No Transactions. Disable ODBC transaction management. All transactions will be automatically committed. This prevents palloc() failures with out-of-memory errors when doing really big transactions such as Exporting 10000 records from MS/Access.

OpenLink Parameters

Figure5.71.OpenLink Parameters tab

OpenLink Parameters tab

ODBC Parameters

Figure5.72.ODBC Parameters tab

ODBC Parameters tab

Finish and Test

Figure5.73.Finish and test tab

Finish and test tab

Prev Up Next
5.1.9.ODBC-JDBC Lite Bridges for Java Home 5.1.11.PostgreSQL