Toad World® Forums

Cross-Connect Issues: Unable to connect to any of the specified MySQL Hosts

#1

I use cross connection queries a fair bit, but I am getting an error here that I can't figure out why. I have dont this exact cross connection before without issue. To test, I am just trying to select data from just one of the connections and it is still throwing an error. I can select data from the table on a standard connection, just not in a cross connection editor. I've rebooted, reconnected, refreshed.

Then when running the same query again, I get a different error:

image

Thoughts?

#2

Take a look at the following, from TDP’s installation Guide. Could be the answer, or possible work-around. If this doesn’t work, I encourage you to open a Support Ticket at www.support.quest.com.

Problem
Attempting to execute a cross-connection query using a MySQL ODBC connection (not a native connection) results in the following error: “The table <table name> can not be mapped.”

Solution:

To use a MySQL ODBC connection in a cross-connection query, you must specify a database for the connection.

To specify a database for an existing MySQL ODBC connection

  1. In the Connection/Navigation Manager, right-click the existing MySQL ODBC connection and select Properties.
  2. Click beside the Data source name drop-down list. The ODBC Data Source Administrator dialog opens.
  3. On the User DSN tab, select (highlight) the connection’s MySQL ODBC driver and then click Configure . The MySQL ODBC Configuration dialog displays.
  4. Select a database from the Database list.

Notes:

  • Specifying a database using the Connection Properties Database field does not result in a solution. You must follow the procedure above.
  • You can repeat this procedure at any time to specify a different database.
#3

Im trying to cross connect 2 sql server databases, not MySQL. The ODBC driver setting for each connection is set to ‘default’. The strange thing is that I’ve done this connect many many times before without issue. It’s strange that all of a sudden I’m having issues.

#4

Try renaming your App data dir (import your connections afterward) There are some mappings cached that might affect the issue. I will also have a developer from that area review this post.