Accessing Data direct gives compilation error.
I am using 800xA 6.0.2 and MS office 2016. When 800xA data direct is accessed from 800xainstaller account. It throws error message compile error in hidden module.But same works fine in 800xAservice account .
This issue faced in one of the IM server of the two. Other IM server is working fine in installer account as well.
I have tried reinstalling the MS office and 800xa datadirect.
Please let me know if any one faced this issue?
I assume that you are running the 32-bit version of MS Office, as you said it is working on the same PC as the 800xAService account. My first thought would be to check to see that the "DataDirect.INI" file exists under that user as shown below.
This file gets inserted into the directory when the DataDirect Toolbar is added to Excel as that user. If it is missing, you can try copying the file from the 800xAService account, (same directory path under the 800xAService account user), and see if that works. If not, there are some other files that can be examined, however I would suggest that if further assistance is needed to open a Support Case with your local RAC so that the effort can be traced.