Issue
Users may be unable to log into Open Practice and receive one or more database-related error messages.
- No person found for this log in!
- Error: 3706 Provider Cannot Be Found. It may not be properly installed.
- Error 3709 The connection cannot be used to perform this operation. It is either closed or invalid in this context.
Cause
This error occurs when the required SQL Server Native Client provider is not installed on the workstation or the installed files are corrupted.
Open Practice relies on this provider to establish a connection to the SQL database. If the provider is unavailable, the application generates Error 3706 during login.
Solution
- Close Open Practice.
- Download and install Microsoft SQL Server Native Client.
- The installer may be in [OP drive]:\OP32\Config. If it is not, download from this article or Microsoft Support site.
- Complete the installation wizard.
- Reopen Open Practice and attempt to log in.