Error: [ProvideX][ODBC Driver]Unable to do ORDER BY"

Product:  BizInsight
Applies to:  MAS 90/200
Article Type:  Error 

Summary:
When dragging and dropping the Sub Accounts analysis set, the following error occurs:

Detailed Error Message #1 Error: System.Data.SqlClient.SqlError: OLE DB provider "MSDASQL" for linked server "mas90_PAR" returned message "[ProvideX][ODBC Driver]Unable to do ORDER BY".

Followed by the error:

Error: .Net SqlClient Data Provider: Cannot execute the query "SELECT DISTINCT AC.CompanyCode from {oj GL_AccountSegment ASEG INNER JOIN GL_Account AC on AC.AccountKey = ASEG.AccountKey}" against OLE DB provider "MSDASQL" for linked server "mas90_PAR".  dataset [MAS90_SubAccounts]

Details:
The query being executed requires the use of a temporary file.  The SQL Server service is started using a particular account, most commonly NT Authority\NetworkService.  The temporary file is created in the temporary directory of the SQL Server service account which, by default, is C:\Documents and Settings\NetworkService\LocalSettings\Temp.  When the OLEDB provider attempts to create this temporary file, it uses the credentials of the account that invoked the request which is the BizInsight user’s account.  This user does not have rights to write to the SQL Server service account’s temp directory and causes this error to occur. 

Resolution/Workaround:
To resolve this issue, do the following:
1. Use Process Monitor to identify the temp directory being used by the SQL Server service. 
   a . Download Process Monitor from www.sysinternals.com.
   b. While Process Monitor is running, recreate the error.
   c.  Search the Process Monitor log for the phrase "Access Denied"
   d.  Make a note of the path to which access is being denied.

2. Open Windows Explorer and browse to the directory. If you do not see thedirectory, make sure that Hide protected operating system files is unchecked  in Tools > Folder Options > View tab.

3. Right click and select Properties > Security.

4. Add each BizInsight user’s Windows account to the folder security and give Write permissions.

If the provided Resolution/Workaround does not resolve your issues, please contact BizNet Software Support for further assistance.