Desktop productivity for business analysts and programmers

Help connecting to Teradata through a libname statement.

Reply
New Contributor
Posts: 4

Help connecting to Teradata through a libname statement.

Hello,

I am trying to connect to Teradata by executing a libname statement and it is giving me the following error.

ERROR: Teradata connection: -1 Message Not Found!.


The same libname worked earlier.

Can someone help me with this?

Thanks,

Sunil.

Frequent Contributor
Posts: 139

Re: Help connecting to Teradata through a libname statement.

Can you please post teradata string?

New Contributor
Posts: 4

Re: Help connecting to Teradata through a libname statement.

libname test teradata user=da_sas pw=XXXXXXXXXXXXX database=DPCVCMPVWDB server=TDPROD;

And also, the Teredata client has been upgraded recently. Is there any place on our local machine where we need to update the new version number?

PROC Star
Posts: 1,146

Re: Help connecting to Teradata through a libname statement.

It depends. You need the correct Teradata client on the machine that SAS is executing on. If you are using SAS display manager without connecting remotely to a server, or if you're using Enterprise Guide with the local client, that is your local machine.

If you're connecting remotely using SAS/Connect, or using Enterprise Guide with a server, you need to have the correct client on that machine.

Tom

Ask a Question
Discussion stats
  • 3 replies
  • 499 views
  • 0 likes
  • 3 in conversation