# Cross-Connection SQL

**URL:** <https://forums.toadworld.com/t/cross-connection-sql/27463>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [November 4, 2013, 10:53am UTC](https://forums.toadworld.com/t/cross-connection-sql/27463 "2013-11-04T10:53:56Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian.p.kissler](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@brian.p.kissler](https://forums.toadworld.com/u/brian.p.kissler)\
**Post date:** [November 4, 2013, 10:53am UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/1 "2013-11-04T10:53:56Z")

</div>

I’m trying to use the cross-connection functionality to join data from Teradata ( via ODBC ) and Oracle. I’m able to connect to both databases individually, however when I attempt to join the two data sources, I continue to get a Oracle ODBC Driver Connect login screen, which when I input my credintals, the pop up box continues to appear and the SQL eventually fails with “Can’t address object `XXXXXX, XXXXX`.TABLENAME from cross query engine”

Any ideas on why Cross-connection isn’t working? I have Toad Data Point base 3.3.0.1526 - Trial version. I also have a the base version of Data Analysts 30.1.1734 which results with the same issue.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 4, 2013, 12:03pm UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/2 "2013-11-04T12:03:30Z")

</div>

Can you post a screen shot of what you are experiencing? Also, why are you using ODBC to connect to Teradata. Our native provider is much faster. It would require that you install the Teradata .net provider as we use this instead of ODBC. Although, ODBC is used for cross-connection.

---

<div class="post-metadata">

**Author:** ![brian.p.kissler](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@brian.p.kissler](https://forums.toadworld.com/u/brian.p.kissler)\
**Post date:** [November 4, 2013, 12:52pm UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/3 "2013-11-04T12:52:09Z")

</div>

Please see attached screen shots with the popup I continue to get and the connection properites for Oracle.

Is there an option to enable the connection option for Teradata? I have Teradata SQL Assistant and can connect via .net however I don't like the interface - I pefer toad 🙂

Thanks for your help!

Brian

 ![CrossConnect.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/73e3893c49dcec6ecc1cd5f7da4a2d55336e8bd9.jpeg)

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 4, 2013, 1:13pm UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/4 "2013-11-04T13:13:29Z")

</div>

You should first try setting the ODBC driver on the advance tab. You will have two choices. One will be for the Oracle client that you have installed. Try that first. If that does not work try the ODBC driver by Microsoft.

![4152.odbcdriver.png](https://global.discourse-cdn.com/quest/original/2X/b/b567244582823b68b2922c5089da974a8a865379.png)

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 4, 2013, 1:15pm UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/5 "2013-11-04T13:15:27Z")

</div>

For the .net Teradata connection, create a new connection and from the type drop down use the Teradata type.

 ![Teradata.png](https://global.discourse-cdn.com/quest/original/2X/7/7155b6532263a915f43e03e1b0f8463808a009c4.png)

---

<div class="post-metadata">

**Author:** ![brian.p.kissler](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@brian.p.kissler](https://forums.toadworld.com/u/brian.p.kissler)\
**Post date:** [November 4, 2013, 2:19pm UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/6 "2013-11-04T14:19:12Z")

</div>

I changed the advanced connection settings to use the Oracle in Client11gR2\_32bit driver - This results in the ODBC popup I had earlier, and the Microsoft ODBC for Oracle driver, this results in an error - “Can’t address object `CONNECTION_NAME`.SCHEMA.TABLENAME from cross query engine”.

When I take the same query ( its just a simple pull of one field from one data table), remove the data connection text and run in a single connection editor, it returns results.

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [November 4, 2013, 3:00pm UTC](https://forums.toadworld.com/t/cross-connection-sql/27463/7 "2013-11-04T15:00:29Z")

</div>

I have never seen the connector prompt for user name and password. I am curious, what happens when you enter the correct info? There must be something in your environment that prompts for that. What happens when you go to the ODBC manager and make an Oracle connection. Can you do this and test the connection there?
