7.0 - Unable to edit a query definition for a Query activity in...

Expand / Collapse
 

7.0 - Unable to edit a query definition for a Query activity in YSE after having configured an ODBC connection in the ODBC connections control panel


Article ID: 52105 - Last Review: February 6, 2014

PROBLEM

After you've configured an ODBC connection in the 64-bit ODBC connection control panel ("Administrative Tools > Data Sources (ODBC)"), if you drop a Query activity in a workflow and try to right-click it and select "Edit Query Definition", you get an error message :"Error trying to connect to the database. Please contact your System Administrator". 


CAUSE

YSE is a 32 bits process, so it can't communicate with the ODBC driver. 



RESOLUTION

 Create an identical System DNS entry in the 32-bits ODBC driver panel available at

%systemdrive%\Windows\SysWOW64\odbcad32.exe



APPLIES TO

7.0 

Keywords: ODBC 32bit 64bit query activity 



Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Thursday, February 06, 2014
Last Modified By: andrew_montpetit
Type: FIX
Article not rated yet.
Article has been viewed 4,904 times.
Options