Return
-
Title
Cross Query connection between DB2 & SQL Server gave error "4206 Invalid data source definition" -
Description
A cross connection query between DB2 and SQL Server gave the following error:
“Cross Query Database Error: Got error 4206 'Invalid data source definition: SQL30061N The database name "DCS794FF" was not found at the remote node. SQLSTATE=08004' from HUB”
-
Cause
The database alias is being used to look up the DCS entry to obtain the target database. The database name, instead of the alias, should be used.
-
Resolution
WORKAROUND:
None
STATUS:
Issue fixed in version 3.3. The latest version can be downloaded from the Support Portal -
Defect ID
ST104382 -
Additional Information
You can download it at: http://tda.inside.quest.com/pageloader.jspa?sbinPageName=beta.htm&sbinPageTitle=Toad for Data Analysts Beta Program&product=toaddatapoint