Problem Description:

I have installed the 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:

For Invalid certificate error when using Office 2016 [Excel or Access] please click here.

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

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

Please click on "View Certificate" to install Certificate.

Please click on "Install Certificate" to install Certificate.

Please follow installation steps as 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 click 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 Certificate.

Please follow installation steps as 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 folder/stores.

Please finish the installation by click 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