I have successfully assigned a SAS ODBC connection which points to a SQL server 2005 database and it connects successfully.
However I can't see the tables in my libref library. Does anyone know why this is? Is it an issue with SQL Server 2005 database permissions?
I can bring the SQL Server tables into SAS and use them only if I know the table name.
LIBNAME SQLDB ODBC
PROMPT = "UID = NAME; PWD = NAME; DSN = NAME; SERVER = IPADDRESS; DATABASE = DBNAME; ";