topic Re: TERADATA engine cannot be found in SAS Data Management

TERADATA engine cannot be found

bkf7911 — Thu, 12 Sep 2013 12:30:48 GMT

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

Re: TERADATA engine cannot be found

JosvanderVelden — Thu, 12 Sep 2013 13:42:45 GMT

Verify if you have a license that includes the access to Teradata engine.
You can do this by using: "proc setinit; run;"
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

Re: TERADATA engine cannot be found

JBailey — Mon, 23 Sep 2013 21:13:43 GMT

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

Re: TERADATA engine cannot be found

anjicamsas — Sun, 13 Oct 2019 12:34:50 GMT

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 ?

Re: TERADATA engine cannot be found

Tom — Sun, 13 Oct 2019 15:23:44 GMT

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.

Re: TERADATA engine cannot be found

anjicamsas — Mon, 14 Oct 2019 09:25:04 GMT

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.

Re: TERADATA engine cannot be found

Patrick — Mon, 14 Oct 2019 10:31:15 GMT

@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