Linking to MySQL

Environment:

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 :

[mysql_database]
Trace = Off
TraceFile= stderr
Driver = /usr/lib/libmyodbc.so
DSN = test
SERVER = (here the ip address of your mysql server)

USER =

PASSWORD =
PORT = 3306
#OPTIONS = 1
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