Rsubmit odbc connection is failing

sidpesar — Fri, 12 Oct 2018 16:36:41 GMT

I have Hortonworks Hive odbc driver setup on DESKTOP A. So when I execute below command

libname titan odbc dsn=titan schema=prod_xxxx;

it is SUCCESSFUL

But when I am trying to run using RSUBMIT from DESKTOP B though connection RSUBMIT is SUCCESSFUL but i am encountering with below error

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified:
ERROR: Error in the LIBNAME statement.

Note: The odbc is authenticated with kerberos.

Re: Rsubmit odbc connection is failing

ChrisHemedinger — Fri, 12 Oct 2018 18:48:10 GMT

Is the DSN a machine/system DSN or a User DSN? That might make a difference.

Also, if using Kerberos or IWA, there might be a Trusted for Delegation change needed. With the RSUBMIT, you're introducing an addition network hop between the client(s) and the target database.

Moving this topic to Data Management for more experts to see it.

topic Rsubmit odbc connection is failing in SAS Data Management

Rsubmit odbc connection is failing

Re: Rsubmit odbc connection is failing