BookmarkSubscribeRSS Feed
sidpesar
Obsidian | Level 7

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

Spoiler
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

 

Spoiler
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.

1 REPLY 1
ChrisHemedinger
Community Manager

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.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1157 views
  • 0 likes
  • 2 in conversation