https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5159#M2087 Hi:<BR /> This is not really an ODS or Base Reporting Procedure (PRINT, REPORT, TABULATE) question. Your best bet for help with using ODBC and SQL server is to contact Tech Support.<BR /> <BR /> cynthia Mon, 22 Oct 2007 15:34:59 GMT Cynthia_sas 2007-10-22T15:34:59Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5158#M2086 Hi,<BR /> I am trying to connect through SAS ODBC to a SQL Server but all I can see are the System Tables and not the tables I want which are in the User Tables.<BR /> Does anyone know how to see the user tables?<BR /> <BR /> This is what I have<BR /> libname mydatabase odbc dsn='mydatabase' schema=dbo;<BR /> <BR /> What do I need to add? Mon, 22 Oct 2007 14:59:51 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5158#M2086 deleted_user 2007-10-22T14:59:51Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5159#M2087 Hi:<BR /> This is not really an ODS or Base Reporting Procedure (PRINT, REPORT, TABULATE) question. Your best bet for help with using ODBC and SQL server is to contact Tech Support.<BR /> <BR /> cynthia Mon, 22 Oct 2007 15:34:59 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5159#M2087 Cynthia_sas 2007-10-22T15:34:59Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5160#M2088 Your schema name is probably wrong. Is the user is the owner of the table ? You might try schema='owner name' Wed, 24 Oct 2007 16:11:56 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-do-you-connect-to-user-tables-thru-ODBC-with-SQL-Server/m-p/5160#M2088 deleted_user 2007-10-24T16:11:56Z