Hi all,
I'm attempting to cross query from Teradata and Oracle in Toad Data Point 6.0.
I currently have Teradata ODBC drivers set up in Toad Data Point 64 Bit ODBC Administrator, and I am able to connect to my Oracle Database without issue in the cross query editor.
I am able to connect to both databases separately in a single connection editor but not in the cross query editor (and only to Oracle in the cross connection).
The following error is as follows:
Cross Query Database Error: Invalid data source definition: Insufficient information to connect to the data source.;Invalid attribute in connection string: CharSet.;Invalid attribute in connection string: CharacterSet.;Invalid attribute in connection string: DBCName.;Invalid attribute in connection string: FBS.;Invalid attribute in connection string: FORWARD_CURSOR.;Invalid attribute in connection string: NO_CACHE.;Invalid attribute in connection string: RunInQuietMode.;Invalid attribute in connection string: SessionMode.;Invalid attribute in connection string: authentication.
The table I'm looking to query populates on the left, and I am able to build it via cross connection SQL builder and extract the SQL. However, when I run the SQL select statement itself, the error gets tripped up. Any help would be greatly appreciated! Thank you.