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