No records or no data in the columns?

Is your connection string pointing to the correct MAS90 directory?

Have you confirmed there are records in the table with DFDM?

Is ODBC Security enabled (although the last time i saw this, the records were returned but the columns were empty)?

v2019.2 Standard, SOTAMAS90, PR2 demo company, ODBC security not enabled, and most PR tables do not appear when creating a new report... so it appears as though they are not exposed to ODBC.

Hi, Make sure you have converted the company data to the current level and accessed the company prior to accessing data files via ODBC.

John Nichols

Sage

I just checked... and PR is not installed on that test system.  (Odd that a few PR tables do show up though).

Yes, I can get data from other tables.

Records yes, as I have a Record Count but no data in the columns

I assumed it had something to do with the PR tables but I'm getting data today!

So while I haven't had this problem lately, I fear this is more of the same of my post "SQL select results fail intermittently, connection is good"

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-personalization-customization-and-productivity-tools/134602/sql-select-results-fail-intermittently-connection-is-good

Hi, If you can connect to other tables and return data but are returning 0 records for PR_PayrollHistoryHeader. 
Then you either do not have permissions to the data or there is no data in that table.

Check with the Sage 100 Administrator to determine if you have ODBC access to the Payroll Files.

John Nichols

Sage