Problem Description:

I have installed QODBC and QuickBooks. I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I hit the Test Connection to QuickBooks button, I get a message from QuickBooks saying The certificate is invalid.

Solution:

Please click here for an invalid certificate error when using Office 2016 [Excel or Access].

Please make sure you are connected to the internet from the machine to validate the certificate.

Please check the property at c:\Windows\SysWOW64\fqqb32.dll or c:\Windows\System32\fqqb32.dll from the "Digital Signature" tab. Please click on "Details" to check the certificate.

Please click on "View Certificate" to install a certificate.

Please click on "Install Certificate" to install a certificate.

Please follow the installation steps below. Select store location "Local Machine" & click "Next."

 Select "Automatically select the certificate store based on the type of the certificate" & click "Next."

Please finish the installation by clicking Finish. After installation, please Restart the machine and Test Connection.

You will be back to the Certificate Window. Please install the certificate again. This time we will install it under "Trusted Publishers."

Please click on "Install Certificate" to install a certificate.

Please follow the installation steps below. Select store location "Local Machine" & click "Next."

Select "Place all certificates in the following store" & click "Browse...".

Select "Trusted Publishers" from the list of folders/stores.

Please finish the installation by clicking on "Finish." After installation, please Restart the machine and Test Connection.

After installation of the first certificate, Please select the second certificate and follow the installation steps, same as above again.

If the above solution does not work, then you need to manually install the certificate by using below link:

http://www.symantec.com/business/support//index?page=content&pmv=print&impressions=&viewlocale=&id=TECH218029

Note: Windows 7 doesn't support SHA256 signatures by default. You need to apply windows up

Refer:

Microsoft security advisory: Availability of SHA-2 code signing support for Windows 7 and Windows Server 2008 R2: March 10, 2015

Microsoft Security Advisory 2949927

You cannot run an application that is signed with an SHA-256 certificate on a computer that is running Windows Vista SP2 or Windows Server 2008 SP2

SHA2 and Windows