BookmarkSubscribeRSS Feed
shparber_m
Fluorite | Level 6
This does give me a list of tables, but from the "master" database, not the DB I need. I tried adding database= and db= and catalog= but i get errors.
I think in the ODBC driver configurations there is no default database specified, so I need to do it in the libname statement, which I do (DATABASE=).
I know the libname is working because it is creating tables in the SQL. It is just not showing them in the SASApp libraries.
Nigel_Pain
Lapis Lazuli | Level 10

If you don't have the database specified in the DSN, it'll use the master database by default. Check out the contents of your odbc.ini file (if you're not on a Windows machine). Or else use a complete connection string rather than specifying a DSN. https://www.connectionstrings.com/microsoft-odbc-driver-13-for-sql-server/ has some guidance on this.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 31 replies
  • 5937 views
  • 5 likes
  • 8 in conversation