Salesforce

ODBC Gateway on the Linux Platform (Magic xpa 3.x)

Printable View
« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

ODBC Gateway on the Linux Platform (Magic xpa 3.x)

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. Uncomment means to remove the semicolon preceding the entry.

  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 set up 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 the Magic Configuration File (MAGIC.INI)

  1. Set a Magic xpa database using the Database repository.

  2. Copy the database definition in the MAGIC_DATABASES section from the MAGIC.INI file on Windows to the MAGIC.INI file on Linux. It is highly recommended to backup the MAGIC.INI file before editing.

Reference
Attachment 
Attachment