|
|
|
July 2003 |
|
|
Information About |
|
|
|
|
|
|
|
|
|
|
|
General information Gateway name: mgodbc Required software: This gateway works with the UnixODBC ODBC manager. It was tested with the following database
gateways: MySQL MyODBC driver (libmyodbc-<ver>.so)
– to access MyODBC software and for more
information on this particular driver refer to http://www.mysql.com Installation and setup instructions 1. Uncomment the entry MAGIC_DB_20_DRIVER
in the mgenv file . 2. Install the UnixODBC
ODBC manager, this product can be downloaded from: http://www.unixodbc.org. Follow the
online instructions to generate the ODBC manager. Locate the following two files (shared
libraries): libodbc.so.1.0.0 and libodbcinst.so.1.0.0 Copy the files to the directory $MAGIC_HOME/lib. 3. In the same directory create symbolic
links for the two libraries: ln –s libodbc.so.1.0.0 libodbc.so.1 ln –s libodbcinst.so.1.0.0 libodbcinst.so.1 4. Install the ODBC driver. Refer to the
specific driver documentation for installation instructions. 5. Make sure that the libraries have
Execute permission. Use the chmod
+x command to set execute permission. 6. Create a hidden file named .odbc.ini in
the user’s home directory. For example /usr/magicadm/.odbc.ini . This file is used to configure ODBC DSNs. Refer to the ODBC manager documentation for more
explanations regarding the setup of this file. To help you setup quickly, we have
included the following .odbc.ini file as an example: [mysql] Driver
= /usr/magicadm/mysql/libmyodbc-2.50.23.so Trace
= No Tracefile= mysql.log Database = samp_db Each section defines a DSN (Data Source
Name). In the above example, there is one defined DSN named mysql. The driver entry in each section should be set to
the full path of the ODBC driver. For a list of valid entries and their
meanings, refer to the ODBC driver documentation Alternatively a general /etc/odbc.ini file
can be used Setting Magic configuration file
(MAGIC.INI) Set a Magic Database using the Magic
Toolkit (Settings->Database screen) For more details,
refer to the Magic Reference documentation. Copy the database definition in the MAGIC_DATABASES section from the MAGIC.INI on Windows to the MAGIC.INI on Linux. It is highly recommended to backup the MAGIC.INI before editing. |
|
|
|
|
|
|
|
Thank you, The Magic Version 9 Team |
|
|
|
|
|
|
|
|
|