Problems with connecting to Teradata and requesting prompt (BASE SAS)

[SASGeek]

Hello,

My company just got access to data on a Teradata server and I have a question about logging in. The server requires a UID and a password. When we logged into the MS SQL server via ODBC we used allow authenthication so we wrote: CONNECT TO ODBC AS AAA (dsn='abcdef); When we had connections to the mainframe it was CONNECT TO ODBC AS AAA (prompt = dsn='abdcef);  The latter worked well.

Now with the Teradata server I need to add my UID and password but the PROMPT= doesn't seem to work. We can't store the passwords or UIDs so I can't do a reference to external files. That said, any other suggestions?

I'm using BASE 9.4.3M and I'd rather not use EG.

Any other thoughts or samples?

Thank you

[SASKiwi · Accepted solution]

Please post your CONNECT or LIBNAME statement SAS log including any SAS notes or errors. What engine are you using when connecting to Teradata? Check with your SAS administrator. Has SAS been correctly configured and tested to work with Teradata? 

[SASGeek]

Thanks. Will do.