Toad World® Forums

Oracle Teradata Connection

I have Oracle and Teradata ODBC drivers installed, and can connect to both at the same time. But when I try to build a query in cross-connection mode, I get the error *Unable to connect to any of the specified MySQL hosts. * I don’t have MySQL, and have never used MySQL, so there must be some other problem that is causing this.

That error usually happens when there is an issue with the local storage, which we use in part with X-Query. Are you able to connect to local storage?

This is my first experience with Toad Data Point. I’m not sure what connecting to local storage refers to. I am able to connect to the Teradata data base and then also connect to the Oracle database (while still connected to the Teradata database), and am able to run queries against each independently. It is when I switch the query build mode to cross connection that I get the MySQL error.

From: Ryan Johnson [mailto:bounce-RyanJohnson@toadworld.com]

Sent: Wednesday, September 30, 2015 5:27 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Oracle Teradata Connection

RE: Oracle Teradata Connection

Reply by Ryan Johnson

That error usually happens when there is an issue with the local storage, which we use in part with X-Query. Are you able to connect to local storage?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

Lance, here is a reply I recently received from Igor that may address your question

Reply by Igor Manokhin

Sorry for the late response. X-Query is actually run on the local hub which is MySql-based engine. That is why X-Queries should conform with MySql syntax. That is why DATEDIFF with 3 params is producing the error.

Igor.

CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication.

“lance.christenson” bounce-lancechristenson@toadworld.com 10/1/2015 9:19 AM >>>

RE: Oracle Teradata Connection

Reply by lance.christenson
This is my first experience with Toad Data Point. I’m not sure what connecting to local storage refers to. I am able to connect to the Teradata data base and then also connect to the Oracle database (while still connected to the Teradata database), and am able to run queries against each independently. It is when I switch the query build mode to cross connection that I get the MySQL error.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum

Flag this post as spam/abuse.

Well, it is likely a hub issue. You will need to reset it. You will lose anything you had in the local storage.

First, open TDP, go to options, then Local Storage -> General. You should see this:

Make note of this folder and shut down TDP. Navigate to this folder and delete or rename it. Restart TDP and let me know if it is working again or not :slight_smile: