topic Re: SAS/ACCESS interface to Teradata cannot be loaded in SAS Data Management

SAS/ACCESS interface to Teradata cannot be loaded

knn1888 — Thu, 18 Jun 2020 23:32:35 GMT

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?

Re: SAS/ACCESS interface to Teradata cannot be loaded

SASKiwi — Fri, 19 Jun 2020 00:22:59 GMT

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.

Re: SAS/ACCESS interface to Teradata cannot be loaded

knn1888 — Fri, 19 Jun 2020 05:10:12 GMT

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?

Re: SAS/ACCESS interface to Teradata cannot be loaded

LouGalway_sas — Fri, 19 Jun 2020 11:42:53 GMT

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

Good Luck

Re: SAS/ACCESS interface to Teradata cannot be loaded

knn1888 — Fri, 19 Jun 2020 16:00:00 GMT

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

Re: SAS/ACCESS interface to Teradata cannot be loaded

LouGalway_sas — Fri, 19 Jun 2020 16:06:21 GMT

For windows use this link: https://support.sas.com/documentation/installcenter/en/ikfdtnwx6cg/66385/PDF/default/config.pdf pg23

Re: SAS/ACCESS interface to Teradata cannot be loaded

JBailey — Fri, 28 Aug 2020 13:36:20 GMT

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