Error: .Net SqlClient Data Provider: An error occurred while preparing the query

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

Summary:
A user drills down on a BizInsight function to view the transaction details for that cell and receives the following error message:

Error: .Net SqlClient Data Provider: An error occurred while preparing the query "select ... " for execution against OLE DB provider "MSDASQL" for linked server "mas90_XXX".  dataset [MAS90_Transactions_All]

Details:
This error occurs when the MAS 90 4.0 ODBC driver is not version 4.21.1000.00.  This can be the case when the MAS 90/200 version is either 4.1 or  4.2. 

Resolution/Workaround:
To resolve this issue, the 4.21 version of the ODBC driver on the MAS 90/200 server must be installed.  Do the following:

 1. Backup the current ODBC driver files as a precaution.
     a) Open Windows Explorer and browse to C:\Windows\System32.
     b) Locate and rename the pvxio.dll and pvxodbc.dll files by appending .SAVE on the end of the file name.

2. Download the ODBC v4.21.1000 driver.  The new ODBC driver can be downloaded from http://www.pvx.com/downloads/download.pvs?file=00115.

3. Install the ODBC driver
     a) Double-click on the executable - odbc-client-4.21.1000-windows-32bit-x86.exe.
     b) Click on Run at the Security Warning.
     c) Click Next.
     d) Read the Software License Agreement and, if you accept the agreement, select the I accept… radio button and click Next.
     e) Complete the User Name and Organization fields and click Next.
     f) Select the Client Side Licensing radio button and check the Allow the ODBC driver to write to data files check box.  Click Next.
     g) The Activation Information dialog should already be filled in with your licensing information.  Click Next.
     h) Click Install.
     i) Click Finish.

 4. Replace the ODBC driver files with the new ones just installed.
     a) Open Windows Explorer and browse to C:\Program Files\Sage Software\ProvideX ODBC Driver
     b) Copy the pvxio.dll and pvxodbc.dll files
     c) Browse to C:\Windows\System32
     d) Paste the copied files.  IMPORTANT:  If you get a message asking you to replace existing files, click No and make sure you have performed Step 1 above and backed up the existing files.
 
5.  Open the ODBC Administrator dialog and check that your MAS 90 4.0 ODBC driver is now version 4.21.1000.00

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