[QODBC-Desktop] Troubleshooting: QuickBooks Error: Invalid Certificate
Posted by Rajendra Dewani (QODBC Support) on 17 April 2014 10:53 AM
|
|
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:
Note: Windows 7 doesn't support SHA256 signatures by default. You need to apply windows up Refer: | |
|