Linking to MySQL


MySQL Server Linex
Client Mac OSX

First, you have to install odbc driver for mysql (myodbc), create a new dsn with the odbc manager, on a linux box, just create a new file /root/.odbc.ini :

Trace = Off
TraceFile= stderr
Driver = /usr/lib/
DSN = test
SERVER = (here the ip address of your mysql server)


PORT = 3306
DATABASE= mydatabase

#SOCKET = /tmp/mysql.sock

Next, create a new sql session in the omnis sql browser:
session name= your_session_name
hostname =mysql_database
data access module=DODBC
user, pass etc..

session>open>your_session_name : you are now connected

Don't forget to grant privilege (name+ip_address) in your mysql server