1. Regenerate the AdxOdbc file
A. The recomended way to resolve the issue with AdxODBC file is to re-save the folder password in the X3 Console
NOTE: You do not need to change the password, but re-save the existing password
a. Ensure no users are connected to the folder concerned
b. Launch X3 Console
c. Connect to the solution
d. Click the "Folders" button
e. Select the appropriate folder in the right hand pane
f. Click the "Password" button
g. Enter the old password
h. Enter then re-confirm the new password. NOTE: this should be the same as the old password, unless you are following the full process to change a folder password
i. Click "Yes" to confirm the configuration
j. Once completed, you can exit X3 Console
k. Check your report printout works OK
B. As an alternative, if you cannot access the X3 console, you can recreate the adxodbc file from the command line using the following steps:
a. Ensure no users are connected to the folder concerned
b. Use SQL Server Managment Server to test the folder name and password work OK
c. Launch CMD prompt
d. cd to the ...\runtime\bin directory
e. Run command "env.bat" to setup environment variables
f. cd to child folder for example "D:\Sage\X3ERPV12\Folders\SEED"
g. Run the following command:
adxodbc -u <> -p <> -b <>** -d <>** <>
** This information can be found in the solution.xml file in ...\Folders\solutions.xml
SQLBASE = database.adonix.sqlbase
RUNTIME_NAME=component.runtime.name
For example
adxodbc -u SEED -p tiger -b x3erpv12 -d X3ERPV12 SEED
You can now confirm that the adxodbc file has been created in ...\Folders\<> and then re-test your report to confirm it now works as expected
2. If you have ORAPSSE.adx in the child folder TRT folder, this should be removed