Crystal Reports' subreport can't login
I am recently switching the data connection of a crystal report from oledb to odbc.
It is tested with 32bit platform, which is fine.
After the report is moved to 64bit platform with Oracle ODBC driver of same DSN name, some subreports cause error as follow:
An exception of type 'CrystalDecisions.CrystalReports.Engine.LogOnException' occurred in CrystalDecisions.ReportAppServer.DataSetConversion.dll but was not handled in user code
Additional information: Database logon failed.
I deleted the subreports from main report, the main report can be shown.
I have set all subreport "data location" from oledb to odbc and verify that all data location is connected to the same ODBC DSN.
Are there any way to determinate which connection is in use at runtime?
Platform: Windows Server 2012R2 64bits
Data Connection: Oracle ODBC Driver 64bits
Connectivity Client: OracleClient12cR1 64bits
Database: Oracle12cR1 64bits
Crystal Report Runtime: SP14
Design Tools: Crystal Report for Visual Studio SP14, Crystal Report for 2013
Development Tools: VS2013
Would anyone please help. thank you very much.