Get Data Moving 1
Results 1 to 2 of 2

Thread: Troubleshooting ODBC Drivers (ODBC Tracing)

  1. #1
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    Troubleshooting ODBC Drivers (ODBC Tracing)

    DESCRIPTION

    The ODBC troubleshooting can be just one side of the process, since, the ODBC client could be running on a different platform than the server. For example, ODBC on the Unix, accessing a remote Database on the AS/400 machine.

    You will get the ODBC trace on the machine where the ODBC application is running.

    SOLUTION

    To enable the ODBC Tracing you need to enable the apiTrace by setting it's value to 'true' in the binding where the driver is defined.

    By default the apiTrace is not shown in the Edit Binding/debug of the Attunity Studio. To enable this option you should set the Studio to show the Advanced settings:
    • Click on the Window menu then Preferences.
    • Click on Studio then the Advanced tab on the right.
    • Enable the "Show advanced environment paramters" option:
    • Edit the target binding where the Driver is defined.
    • Expand the "debug" section and set the apiTrace to 'true'.
    The ODBC Tracing will be appended to the Attunity Server log files.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    ODBC Tracing on Windows using the ODBC Data Source Administrator

    DESCRIPTION

    On the Windows platform you can enable the ODBC Tracing of the ODBC Data Source Administrator.

    In this case you will get ODBC Tracing when the ODBC DataSource is being called from a 3rd party application (or program). The advantage in this case is that you can catch failures which may occur before the Attunity Driver is being initialized.

    SOLUTION

    Here are the steps for enabling the ODBC Tracing using the ODBC Driver Manager:
    • Launch the ODBC Data Administrator tool.
    Depending on the version of the Windows operation system, this could be located in the Control Panel or Administrative Tools as "Data Sources (ODBC)" icon.
    • Click on the "Tracing" tab.
    • Enable "Machine-Wide tracing for all user identities" if the target process is not running under the current identity.
    • Modify the "Log File Path" if required, make sure to delete the log file or empty in order to get a clean log file.
    • Click on "Start Tracing Now" to start the tracing.
    • Run the problematic scenario.
    Tracing will cease only when clicking the "Stop Tracing Now".
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •