Hello. I successfully set up an ODBC connection on my PC and tested it by connecting to tables using MS Access. The following libname statement references that same odbc connection and completes successfully.
libname srcdata odbc datasrc='DM_training_layer' user='UserID' pw='XXXXX' schema="UserID"
PRESERVE_TAB_NAMES = no PRESERVE_TAB_NAMES = no readbuff=1000 access=readonly;'
However, when I do a proc datasets or try to reference the tables that I know exist, I get the following: