SAS Teradata ODBC Connection
Posted on 2011-09-30
I am relatively new to SAS. I am using Enterprise Guide 4.1 and trying to connect to a Teradata DB using ODBC. My Teradata client uses ODBC to connect to the server and I have successfully used the same ODBC to connect using R.
If I click on File->Open->ODBC... then select the same ODBC data source as I use in R and Teradata client, input my password and click OK I get the error message
Enterprise Guide cannot open the data file: ODBC;DSN=my_odbc_name; UID=my_username;PWD=*******;
Error opening data "ODBC;DSN=my_odbc_name; UID=my_username;PWD=my_password; ".
Failed to open the data set in READ mode.
Do you want to remove all references to this file from the project?
What am I doing wrong?