If you are receiving the following error when trying to upload a journal using the journal upload template:
An error has occurred attempting to connect to the database. Please check your login details and try again.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Then please see the following:
This occurs when the ODBC name is incorrect or the login details are incorrect in the connection setup of the journal upload template. To resolve this issue:
Open up Dimensions but stay on the login screen.
In the bottom right, click More >.
In the ODBC Data Link field, note the correct name of the ODBC connection.
Go back to your standalone journal and at the top, click Add-ins.
Click Journal Import.
Click Setup.
Change ODBC Datasource to use the ODBC Connection name from step 3.
Ensure that the correct credentials are used in the connection.
Click OK.
Please note, if you are a Access Financials customer then you will be able to use the Hosting Admin credentials within the Journal Setup section.
If you still get the same error after using the same ODBC connection as used for Dimensions, then check you have the correct bit type for the ODBC data source. The ODBC data source bit type needs to be the same as the bit type of Excel that you are using.
To check the bit type of Excel, in Excel, choose File, Account, About Excel and note whether it is a 32-bit or 64-bit version.
If it is a 64-bit version, then you will need to create a separate/additional 64-bit ODBC data source for the Dimensions database.
Use the ODBC Data Sources (64-bit) application rather than the 32-bit version. Note, this 64-bit ODBC data source cannot be used in the Dimensions application. It will only work for the journal uploader template in 64-bit Excel.
Then use the above instructions to update the journal template setup to use the 64-bit ODBC source that you have just created.