TERADATA engine cannot be found

[bkf7911]

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

[JosvanderVelden]

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]

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]

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]

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]

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]

@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