# Cross-connection does not work - found {

**URL:** <https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [October 19, 2011, 10:23am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928 "2011-10-19T10:23:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kixtart](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kixtart](https://forums.toadworld.com/u/Kixtart)\
**Post date:** [October 19, 2011, 10:23am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/1 "2011-10-19T10:23:03Z")

</div>

Hello,

I’m trying to create a cross-connection and getting the following error each time. Normal direct queries and such are functioning correctly.  
ERROR line 2, col 7, ending\_line 2, ending\_col 7, Found ‘{’, Expecting: OJ

I’ve used the cross-connection query browser to get to the following query (removed some nonpublic-arguments):  
SELECT rf.\*

SELECT PH.\*

FROM {{Odbc(“Dsn=CMO1P-NLY;uid=\*\*\*\*;pwd={0};fwc=T,40420C4359F094FA19CDED908560AA75”)}}.“SCHEMANAME.TABLENAME” PH

FROM {{Odbc(“DRIVER=SQL Server;SERVER= **;UID=;APP=Toad for Data Analysts;WSID=** ;\*\*\*\*;Trusted\_Connection=Yes;PWD={0};,”)}}.TABLENAME rf

Same happens at ODBC connections while the DSN-connection works correctly in Excel for example:

---

<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:** [October 19, 2011, 11:45pm UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/2 "2011-10-19T23:45:34Z")

</div>

What version of TDA are you using? If you are using TDA 3.0 Base edition, it is a known issue that cross-conneciton is broken. We have this fixed and will be released in a patch 3.0.1.

But we have put all of our efforts into the Professional cross-conneciton query engine. This is a totally new engine that is far better than the base edition (the base editon uses access). I suggest you download and try TDA 3.0 trial for cross-connection.

Debbie

---

<div class="post-metadata">

**Author:** ![Kixtart](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kixtart](https://forums.toadworld.com/u/Kixtart)\
**Post date:** [October 20, 2011, 2:43am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/3 "2011-10-20T02:43:17Z")

</div>

Hello,

It is TDA 3.0 Base edition with use of Cross-connection SQL/Query/… (Pro Edition) in trial phase. This is the one you mean right?

---

<div class="post-metadata">

**Author:** ![sukhan\_109](https://avatars.discourse-cdn.com/v4/letter/s/ecc23a/32.png) [@sukhan\_109](https://forums.toadworld.com/u/sukhan_109)\
**Post date:** [October 20, 2011, 10:18am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/4 "2011-10-20T10:18:00Z")

</div>

I have 3.0.0.1694. When is 3.0.1 expected?

---

<div class="post-metadata">

**Author:** ![Kixtart](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kixtart](https://forums.toadworld.com/u/Kixtart)\
**Post date:** [October 20, 2011, 10:48am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/5 "2011-10-20T10:48:40Z")

</div>

This guy is not me, but I have the same version and question 🙂

---

<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:** [October 20, 2011, 10:54am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/6 "2011-10-20T10:54:47Z")

</div>

The 3.0.1 patch is scheduled to be released on Nov 1st. It is a very quick patch covering the following things:

-Cross-conneciton execution in Base edition  
-Unicode support for Data Cleansing and Local Storage  
-Filter migration from 2.7 to 3.0

Debbie

---

<div class="post-metadata">

**Author:** ![Kixtart](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kixtart](https://forums.toadworld.com/u/Kixtart)\
**Post date:** [October 21, 2011, 4:18am UTC](https://forums.toadworld.com/t/cross-connection-does-not-work-found/6928/7 "2011-10-21T04:18:57Z")

</div>

Thank you for the quick response!
