Excel query to MSSQL database to Pervasive SQL not working

We are running Sage 300 Real Estate and construction v14.1.  Our Timberline users run an excel add-in query to extract data from the Timberline database to use for analysis.  The query first connects to a SQL server which has an ODBC connection to the Pervasive database.  If our timberline sys admin runs the excel add-in query, he gets no errors and it works fine.  When a Timberline business user runs the excel add-in query, they are receiving a SQL exception error stating 'cannot initialize the data source object of OLE DB provider "MSDASQL for linked server.   Any help or guidance is appreciated.