BookmarkSubscribeRSS Feed
bkf7911
Calcite | Level 5

I am receiving an error message that The TERADATA engine cannot be found when I try to setup a library for a Teradata connection to a database.  I can query this database via Teradata SQL Assistant and can also setup an ODBC connection to the database from SAS.  But I need to make the Teradata connection so that I can send data into the database to query against data already there.

34   libname mvpvu teradata user="&dduser." password="&ddpass." tdpid=mvp

34 ! database=MVP_DS;

ERROR: The TERADATA engine cannot be found.

ERROR: Error in the LIBNAME statement

6 REPLIES 6
JosvanderVelden
SAS Super FREQ
  1. Verify if you have a license that includes the access to Teradata engine.
    You can do this by using: "proc setinit; run;"
  2. And if yes verify if the access to Teradata engine is installed.
    On windows verify for the presence of the binaries.
    To do this, go to the Windows Explorer and look in the
         !sasroot\access\sasexe
    subdirectory for      SASIOTRA.DLL      and    SASTRA.DLL.
    If you do not see these DLLs listed, then you do not have this product installed.

Cheers, Jos

JBailey
Barite | Level 11

Hi,

It looks like SAS/ACCESS Interface to Teradata is not installed.

Do you have the files sasiotpt.dll and sasiotra.dll in your %SASHOME%\SASFoundation\9.4\access\sasexe directory? If those files aren't there you don't have SAS/ACCESS to Teradata installed.

Best wishes,

Jeff

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 ?
Tom
Super User Tom
Super User

PROC SETINIT will show you what is licensed. PROC PRODUCT_STATUS will show you want is installed.

Looks like they did not install the Teradata access module on the copy of SAS  you are running.  Talk to whoever setup SAS for you to use.  They probably just need to re-install SAS making sure to include that module.

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 

Googling with keyworrds: sas libname name not in HOSTS file or names database 

...let me find the following SAS Note which should explain it: http://support.sas.com/kb/54/851.html

 

You could also try and add libname option SERVER='<name of teradata server> and see it this helps.

http://support.sas.com/kb/57/679.html 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 6 replies
  • 6534 views
  • 0 likes
  • 6 in conversation