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
© JACSoft Programming Ltd.
We will respect the author's
intent with articles that are published on our website and
if appropriate will honor any request to remove the article if its
presence on this web
site is found to violate a copyright or the wishes of the author(s).
Please email
remove@jacsoft.co.nz
should you wish to request this.