ABSS Premier ODBC version conflict

When using BI4Cloud on ABSS Premier only one ODBC driver should be installed at the same time. If not then when you connect BI to a Premier file you will get an error

"ERROR [HZ080][ABSS Pte Ltd ODBC] - The Company file selected is not compatible with the version of the ABSS ODBC driver " 

01_bi4_error.png

This indicates there is more than one ODBC driver installed.

Normally the ODBC drivers can be uninstalled using Programs and Features.

However it has been found  (26oct18) that if a newer version of ABSS Premier is installed then the older version of Premier does NOT uninstall the ODBC drivers correctly.

This can  be verified by running C:\Windows\SysWOW64\odbcad32.exe and looking at drivers tab and ensuring the ODBC driver in question is removed. If it shows the driver is still there then you will have a problem. This is what the problem looks like 

01_Partial_unistalled_ODBC_1402.png

In the case we encountered the environment was

  • Windows 2012 R2
  • ABSS Premier v20 ( ODBC MY 1402 )
  • ABSS Premier v22 ( ODBC MY 1601 )

Your particular case may have different versions.

The work around

1. To fix this issue you need to uninstall the newer product and it's ODBC first and then the older product and it's ODBC driver until all the products and their ODBC driver are removed AND then install the version of Premier you intend to use.

Before you start ensure you have backups of your data files

2. Ensure you have both the old and the new versions of Premier installed. Looking at Programs and Features in our example

 

01_both_Premier_v20_v22.png

3. Using the Uninstall option of Programs and Features uninstall the version of ODBC and then the version of Premier starting from the newest first. This MUST be done in this sequence. So in our example

  • uninstall ABSS ODBC Direct v16.0 MY
  • uninstall ABSS Premier v22 MY
  • uninstall ABSS ODBC Direct v14.0 MY
  • uninstall ABSS Premier v20 MY

4. When ALL the Premier and ODBC is uninstalled use C:\Windows\SysWOW64\odbcad32.exe and ensure the ABSS driver in the Drivers tab have been removed.

5. Install the version of Premier you plan to run.

You should now be good to connect company files to Bi4Cloud

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk