The SAS Output Delivery System and reporting techniques

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

Reply
N/A
Posts: 0

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

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?
SAS Super FREQ
Posts: 8,743

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

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
N/A
Posts: 0

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

Your schema name is probably wrong. Is the user is the owner of the table ? You might try schema='owner name'
Ask a Question
Discussion stats
  • 2 replies
  • 126 views
  • 0 likes
  • 2 in conversation