title: As/400 Library Woes
body: <p>I saw few answered AS/400 questions out there, but I hope I can be one of the lucky few whose question gets answered. </p>
  
  <p>So I have crystal reports that run queries on multiple AS/400 files through an ODBC connection. Problem i am facing is that the reports are only trying to access records that are in the default file listed in the ODBC and it does not traverse the list of libraries (which incidentally has most of the records). </p>
  
  <p>How can I go about troubleshooting this error, or is there some option that I may have failed to enable in order to have the ODBC traverse the list as opposed to only view the default Library? </p>