Xero Driver always has to reconnect when trying to run reports

Xero Driver always has to reconnect when trying to run reports

Issue
When connecting Alchemex and Xero, you are continuously prompted to reconnect to Xero and provide authentication. Normally you will get a prompt when trying to run a report.


Resolution
Store the connection properties by updating the ODBC Driver Properties
E.g. Add OAuthSettingsLocation=C:\SIMetadata\XeroDriver\Connections.txt in the OTHER Property of the connection.


    • Related Articles

    • Data Source name not found and no default driver specified. SQLState=IM002

      Error "Data Source name not found and no default driver specified. SQLState=IM002" when trying to run any reports Resolution Go to the Connector Find the connection the report with the error is running off Ensure the report is on the correct ...

    • Deploying CData drivers using Citrix Machine Creation Services

      Issue: You are trying to license the CData drivers as per normal, but when you are spinning out new instances, the license is not holding on the newly created machine. Symptoms: You try and Test the connection to the drivers through the ODBC Driver ...

    • Testing Connections and Troubleshooting Connection Errors

      OVERVIEW One of the main functions of the Sage Intelligence software is to connect to a data source(s) and retrieve data; these connections are made through the appropriate ODBC driver(s). Because of this reliance on the ODBC drivers, errors can ...

    • Working with connections in Intelligence Reporting

      Creating New Database Connection A Data Connection holds the relevant connection information to connect to a supported ODBC or OLEDB compliant data source. This data connection object is then used for all connections to this data source. By adding a ...

    • Modelling Data using the RESTful ODBC Driver

      To model the table's column-information in the desired way, you need to first generate the schema of your data source. Add the below connection parameter in the DSN Manager of your connection wizard:     Generating Schema Files Under the Connection ...