Applicable Versions: 6.00 Onwards
In the situation that the connection to SQL is using an ODBC connection like "DSN=HostAdv14". Then you need to set up 2 identically named ODBC DSN's using the Windows ODBC tool. One being a 64 bit, the other 32 bit.
The Analytics Engine and Dashboard designer and both 64 bit, but the Report designer is still 32 bit so both ODBC Definitions need to be created with the same name.