06-22-2016 02:54 AM
I am trying to execute the below code by sing BASE/ SAS:
libname rams teradata user=sas_user password=XXXXX database=database server=prod;
it is showing the below error. Can you please provide your valuable inputs asap.
Error: The SAS/ACCESS interface to TeraData cannot be loaded. The SASTRA code appendage could not be loaded.
Please let me know what are the prerequisites to connect to the Teradata DB as it is a first time access.
06-22-2016 03:19 AM
Yes ..it is licensed version.
When I run proc setitin the below log is coming related to teradata. It is in Grace period and we are able to use it for other querying purpose.
SAS/ACCESS Interface to Teradata
When I run product-status, I am getting the below status message.
SAS/ACCESS Interface to Teradata ...
Custom version information: 9.4_M2.
Hence, Please suggest me with the next move.
06-22-2016 03:33 AM
You have to explain your set up.
Are you a desktop SAS or server?
Does ODBC work?
Also, I would contact SAS tech support. They're fast and helpful.
06-22-2016 08:38 AM
From SAS server I am able to connect, but from desktop version only I am trying and I am getting the above mentioned error.
And my next move is, following support.sas.com to resolve the issue. But I am not able to get the exact resolution.
One more question is like..do we need to work with Teradata team to declare any IP address of our Base SAS to get the access?
06-22-2016 09:17 AM
You should definitely work with the TD to resolve any connection and athorization issues, but I don't think your IP is used by default as part of the authorization - but check to be sure.
First step should be to connect to TD from the local (on the SAS server) TD cleint (or any other ODBC client application that can use the TD client ODBC driver) to see if you can connect.
Once verified that par, go on to configure and connect from SAS.
06-22-2016 04:04 PM
Access to RDBMS works like this:
DB client is installed on SAS host
DB connection is configured into the client
Client config information is included in SAS startup files
SAS gets access by using DB client with the connection config
Now, if the specific workspace server that you use from the desktop misses the connection configuration in its startup script, it can't use the DB access.
06-22-2016 03:37 AM
See if one of these provides you with a clue what might go wrong:
02-11-2017 04:08 PM
This error typically means that the product in question (in this case SAS/ACCESS to Teradata) is not installed or is configured improperly. Checking the license file (SETINIT) only tells us if the product is licensed.