CLI error for OAuth authentication

Hans_Luc — Mon, 20 Jan 2020 22:41:58 GMT

I am trying to create a library using code that links to our Dynamics365 Sales database. I am using a piece of software called CData to allow this link.

Currently it only works if I was to create the library manually by going to Tools > New Library, for name I used: PRM, for Engine, I selected: ODBC, for Data Source I chose: CData D365Sales Sys. User ID and Password is the same as my windows login. And Options I've left blank.

The above manual method will force a browser to open with the message OAuth Authorization Successful twice, once for creating the library and another when clicking into the library in the SAS Explorer window.

Now my issue is that I am trying to mimic this in code form. Below is the code I've tried using (I am using SAS 9.4):

%let dsn=CData D365Sales Sys;
libname prm odbc noprompt="dsn=&dsn;Trusted_Connection=yes" schema=DBO access=readonly;

However, I get the following error message. Hoping someone can elaborate what needs to be done as I am unclear from just the error message alone. i.e. where do I find the DSN manager and how to authenticate it?

ERROR: CLI error trying to establish connection: The driver requires a user prompt for OAuth

authentication which is not allowed by this application. Please use the DSN manager to

authenticate before using the driver in this application.

ERROR: Error in the LIBNAME statement.

Re: CLI error for OAuth authentication

SASKiwi — Tue, 21 Jan 2020 05:34:04 GMT

What OS does SAS run on? Your connection string is using Windows Authentication so will only work on Windows. Also your DSN needs to point to a single definition, not three. On Windows the DSN would be defined in the ODBC Administrator on the computer where SAS runs.

Re: CLI error for OAuth authentication

Hans_Luc — Tue, 21 Jan 2020 05:58:08 GMT

I'm using Windows 10. In the ODBC Administrator under the System DSN tab, the Name is "CData D365Sales Sys", Platform is "64-bit", Driver is "CData ODBC Driver for Dynamics 365 Sales"

topic CLI error for OAuth authentication in SAS Data Management

CLI error for OAuth authentication

Re: CLI error for OAuth authentication

Re: CLI error for OAuth authentication