Firedac to cdata Xero ODBC Driver

[HGRogers 0]

Hi

Anyone have any experience of getting the above connection working?

 

In the ODBC Configurator I can get a connection to the Xero data and run simple SQL Select statements using the Cdata provided UI. When I attempt to create a FireDac connection to the ODBC driver it always fails on the OAuth login. The error is :

 

[FireDAC][Phys][ODBC]5 An error was encountered when reading the OAuthSettings: [Please provide a name for the DSN.]. Please try running the application as Administrator or setting 'OAuthSettingsLocation' to an accessible location on disk.

 

The driver has the option set to save the credentials in a local text file that is fully accessible (can open the created file in notepad). Running FireDac explorer as administrator produces the same error.   The FireDac parameter  named 'Datasource' is set to the named DSN - from a populated dropdown so it's not a typo. 

 

An hour with support at Cdata has not got nearer a solution.

 

Many thanks for any input

Edited October 24 by HGRogers
misspelt

[HGRogers 0]

Whilst nobody chimed in - bit niche? 

Maybe there is someone with some general observations that could push me in the right direction? Embarcadero and Cdata have so far failed to come up with a solution.

 

Using the ODBC Admin tool I can gain access to the Xero data. 

Using FireDac Explorer I can gain access to the Xero data.

 

When I use a TFDConnection Delphi comes back with

   External exception E0434352    (which apparently is .NET related?)

 

I've tried Both USER and Systems DSNs - running Delphi as Admin and Normal User , With Both Registry and Local file parameter storage.

I've tried it on Two Different machines  Win 10 and WIn 11, and in both Delphi 10.4 and 13

 

I always get the same result

  FireDac explorer works - Delphi does not    - so anyone any idea as to the possible differences between these two access methods?

 

Thank you.

[Brian Evans 138]

In the FireDAC Connection Editor there is an Info tab should have some detailed information. There is also a SQL Script tab where you can run a script for a basic test.

 

Note ODBC has 32-bit and 64-bit ODBC Administrators and the DSNs are setup in the one that matches your Delphi IDE and/or Delphi application.

 

 

 

 

 

 

 

Edited October 29 by Brian Evans

[HGRogers 0]

Hi Brian, Thanks for the input. 

The problem is I can't get as far as a working FireDac Connection Editor - It blows up when trying to connect. presumably it's using the definition and parameters from Delphi.

The FireDac explorer stand alone exe does however work - when apparently using the same parameters.

I'm using 32bit throughout.

 

All the best