BookmarkSubscribeRSS Feed
knn1888
Calcite | Level 5

Hi all,

 

I'm trying to access Teradata through sas and got this error:

 

ERROR: The SAS/ACCESS Interface to Teradata cannot be loaded. The SASTRA code appendage could not be loaded.

ERROR: A Connection to the teradata DBMS is not currently supported, or is not installed at your site.

 

performed 

proc product_status;

run;

output: 

For SAS/ACCESS Interface to Teradata ...

   Custom version information: 9.4_M1

and 

proc setinit;

output:

---SAS/ACCESS Interface to Teradata                                                                     14JUL2020

I also check the binaries file .dll and I have both of them. Why do I still have this error then?

 

 

6 REPLIES 6
SASKiwi
PROC Star

What OS is SAS running on? Have you gone through the post-install configuration steps? Refer to page 71 of the Configuration Guide for Unix.

knn1888
Calcite | Level 5
Hi There,

I’m running it on Windows as OS not linux. Could you please let me know where I can find the post install configuration steps?
LouGalway_sas
SAS Employee

The link was already given above along with the page number.  Configuration is a hyperlink to the document.

 

Good Luck

knn1888
Calcite | Level 5

I'm not running it on linux but on windows desktop. Could you please point to a different documentation?

JBailey
Barite | Level 11

Hi @knn1888 

 

The "Code Appendage" message most often means that the SAS/ACCESS engine was not installed. See if sasiotra.dll and sasiotpt.dll are in a directory similar to this one: C:\Program Files\SASHome\SASFoundation\9.4\access\sasexe

 

Best wishes,

Jeff

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