How do you connect to user tables thru ODBC with SQL Server?

[deleted_user]

Hi,
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.
Does anyone know how to see the user tables?

This is what I have
libname mydatabase odbc dsn='mydatabase' schema=dbo;

What do I need to add?

[Cynthia_sas]

Hi:
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.

cynthia

[deleted_user]

Your schema name is probably wrong. Is the user is the owner of the table ? You might try schema='owner name'