BookmarkSubscribeRSS Feed
anjicamsas
Calcite | Level 5

when i hit the code (Proc setinit; run;), i am able to see the following in the log.
---SAS/ACCESS Interface to DB2                                                                                                  29NOV2019
---SAS/ACCESS Interface to Oracle                                                                                               29NOV2019
---SAS/ACCESS Interface to PC Files                                                                                               29NOV2019
---SAS/ACCESS Interface to ODBC                                                                                               29NOV2019
---SAS/ACCESS Interface to Teradata                                                                                               29NOV2019
---SAS/ACCESS Interface to MySQL                                                                                               29NOV2019
---SAS/IML Studio                                                                                                                          29NOV2019

but in the folder (C:\Program Files\SASHOME2\SASFoundation\9.4\access\sasexe), i couldnt fine these sasiotpt.dll and sasiotra.dll.

when i try to run any terdata code, i am getting end up with following error.
ERROR: The TERADATA engine cannot be found.
ERROR: A Connection to the teradata DBMS is not currently supported, or is not installed at your site.


WHAT should i do ?

3 REPLIES 3
SASKiwi
PROC Star

Run - proc product_status; run; -  to confirm if SAS/ACCESS Interface to Teradata is installed or not.

anjicamsas
Calcite | Level 5
There are two servers in my ENterprise guide ( local and sasapp)
From SASAPP profile connected,
When i run PROC SETINIT;RUN;

i can see the following (regarding Teradata)
Current version: 9.04.01M5P091317
Operating System: LIN X64 .

---SAS/ACCESS Interface to Oracle 14DEC2019
---SAS/ACCESS Interface to SAP ASE 14DEC2019
---SAS/ACCESS Interface to PC Files 14DEC2019
---SAS/ACCESS Interface to ODBC 14DEC2019
---SAS/ACCESS Interface to Teradata 14DEC2019

When i run PROC PRODUCT_STATUS;RUN;

For SAS/ACCESS Interface to Teradata ...
Custom version information: 9.45


When i try to connect to teradata using below code,
libname trlib teradata user=ABCDEF password=PWDPWD;

i gets following error.

26 libname trlib teradata user=ABCDEF password=XXXXXXXX;
ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS file or names database. .
ERROR: Error in the LIBNAME statement.

What could be the issue. it will be much helpful if i get answer for this.
Patrick
Opal | Level 21

@anjicamsas 

Please ask the same question only once in a single forum. Ongoing discussion here

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1193 views
  • 0 likes
  • 3 in conversation