• ODBC EXCEL 64 BIT AND 32 BIT

    Can someone please assist. I think there are few companies still running systems on 64 bit Excel. Why can't I run or create my ODBC queries on Excel 64 bit? Who would want to downgrade to get results? Is there another way arround this issue please…
  • Version 6.1b - New Companies not running ODBC

    Hi Since updating to version 6.1b we have added two new companies (once copied from an existing and one completely new). ODBC set up was added, users were added and the apply changes were made. All our existing companies can generate both SMART reports…
  • ODBC TABLE LIST

    Is there a full list with all the data that can be extracted i.s.o. searching it in ODBC itself? Thank you
  • SMART Reporting Error VIP Classic

    Hi All, I am getting the following error when trying to run a multi period costing report or MTD report. If I run a report for current period only it works. I have checked user permissions and Excel is 32-Bit.
  • ODBC error

    Please help with the following error in ODBC: ODBC Licensing: Unhandled error. Please contact your distributor.
  • ODBC Error - VIP Company error

    Good day! I am having difficulty with ODBC. I have done the ODBC Setup and allowed all the permissions on all companies. When I run an ODBC query from Excel, I get varying results: One company runs the report and all is well. The two other companies…
  • VIP Report Execution Error (ODBC)

    Good day Yesterday we ran reports on Salaries and today we need reporting on Skills. But the report fails. We followed steps to replace DLL files and check folder permissions, but still. I also checked plug-ins for Excel. Any input?
  • ODBC Driver Manager

    Hi, I am unable to use queries with my MS Excel (64-bit), always getting the error in the screen shot below. Someone kindly help! Regards, Geoffrey
  • Sage Intelligence | VIPODBCInstall over the network issue

    Hello, Our customer was initially using windows 8 to run VIP system over the network located on windows server 2012. Now They have migrated to new computers in which the server housing the VIP system is windows 2019 server and the workstations are running…
  • ODBC Report - New Staff

    Hi, One of my ODBC reports never includes new staff for the month, I have made sure that the report is refreshing for the same month. How do i fix this or do i need to rewrite the report? All my other ODBC reports are working just fine. Please…
  • ODBC Error 4001 and Invalid File Format VPmas???.pay

    Hi All, Note that we've recieved increased amount of queries regarding this notification when we try and run ODBC report and in SMART. We did follow the following steps: Solution ODBC:  Open VIP and log into a company  Click on Utilities > VIP ODBC…
  • ODBC

    Hi all, I have updated y system to version 5.5a. However, I am trying to update the ODBC configuration but the tool screen is not appearing at all. I would really appreciate your urgent assistance on this matter.
  • Bulk Leave Transactions

    Hi Please assist, I have last did this in 2017 and Totally stuck now as I cannot remember all the steps on how to create the smart report template for leave import. I can remember a bit of creating the batch, on VIP, then there is a report on smart…
  • Smart Report Error

    Good After Can anyone advise a solution to the following error on smart reporting
  • How to apply changes in ODBC after a Software update

    Need assistance with updating your ODBC drivers after installing the latest update? Please click on the document below and follow the step by step. 6648.How to Apply changes - ODBC.pdf