Tuesday, November 29, 2022

Solving: 3rd party couldn´t connect to MS SQL DB (Error 800A0E7A)

Issue: A 3rd party application couldn´t connect to a MS SQL Database. In the log from the application you can see the error message 800A0E7A. How can you solve that?

Solution: Most 3rd party applications which need to connect to a MS SQL Database require the “SQL 2005 Native Client”. If this component is missing on the system where you installed the 3rd party application on you might see error messages like the following on the system:

Unable to open database at 'Provider=SQLNCLI;Initial Catalog=NME40DB;Trusted_Connection=yes;':
Source: ADODB.Connection
Description: Provider cannot be found. It may not be properly installed.
Message: Unknown error 0x800A0E7A
Error 800A0E7A

To solve that, download and install the “SQL 2005 Native Client” from here, which fits your OS:

X86 Package
X64 Package

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Stay Connected

24FollowersFollow
- Advertisement -

Latest Articles