DB2 Connections are Not Allowed (4261494)

I am doing a Hetrogeneous query with a DB2 native comnnection and I get:

"DB2 Connections are Not Allowed"

Currently, you cannot create a heterogeneous query that contains objects from a DB2 client connections.
As a workaround, create a ODBC connection using a DSN to the DB2 database and select the objects from the connection.

This requirement will be the same in Toad for Data Analysts 3.1 Base .
It will also be a requirement for XQuery for TeraData and Sybase IQ.

The problem is that Access (which is what we are using for XQuery in Toad for Data Analysts Base) does not allow dynamically created ODBC connections in some cases.
It will only recognize DSNs.
Thus, these connections need to be made by the user.

See Attachment: HOW to create ODBC connection TDA _0.docx

For this error in Toad for Data Analysts, you need to create a DB2 connection using an ODBC connection.You cannot use a native DB2 connection.

For example in TDA 2.7:

1. Select the ODBC from the connection group.
2. Click on the ODBC Data Source Administrator icon,
3. Under the User DSN tab, click on the Add.. button
4. In the New Data Source, find and select for TDA select IBM DB2 OODBC DRIVER – TACOM27 (TACOM27 = Toad for Data Analysts Commercial 2.7 version)
5. Click Finish
6. In the ODBC IBM Driver Window, Decide a Data Source name:
   1. Database Alias
   2. And a description
7. Click on Add
8. In the CLI/ODBC Settings
9. In the Data Source Tab, Input the User name and Password and Save password if desired.
10. In the TCP/IP Tab Input:
    1. The database bane
    2. Database alias
    3. Host &
    4. Port number.
11. Click ok

Now you should see you User Data Source

Make the connection using the Data Source name from the drop down menu.

The rewritten XQuery in the new Toad for Data Analysts Pro edition does not have these restrictions and is useful in a production environment.
If one is interested in the Toad for Data Analysts Pro edition, one can contact their Sales Rep for additional information.