troubleshooting-database-connectivity-issues-in-expectations.md

cover	coverY	layout
../../../.gitbook/assets/DALL·E 2024-11-16 12.54.51 - A professional masthead image for an article on troubleshooting database connections. The image features abstract representations of server connection.webp	22	cover title description tableOfContents outline pagination visible size true full visible true visible visible true visible true visible true

Troubleshooting Database Connectivity Issues in Expectations

This guide helps troubleshoot database connectivity problems in Expectations, considering its requirement for both x86 and x64 OLEDB drivers. These products depend on the MSOLEDBSQL provider for connectivity.

Prerequisite

Installation of the Microsoft Visual C++ Redistributable is a prerequisite, and while the x64 installer for Microsoft OLE DB Driver installs both the 64-bit and 32-bit driver, the x64 installer for the Microsoft Visual C++ Redistributable doesn't install 32-bit binaries. You must install both the x86 and x64 versions of the C++ redistributable package to install the x64 OLE DB driver package. You may be asked to restart the computer.

Install OLEDB Drivers

Expectations requires version 18.7.4 version of the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). Some Windows systems do not come with this driver already installed. Follow the directions below to install them.

• Visit the official Microsoft download page: https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#
• Download x64 version of the 18.7.4 MSOLEDBSQL driver
• Run both installers, following the on-screen prompts.

Install .NET Framework

• Expectations .NET Framework version 4.7 or greater.
• Please install the .Net Framework runtime version 4.8 or 4.8.1

Restart Your System

• Restart your computer after driver installations to apply changes.

Verify Installation

• Confirm both OLEDB drivers are listed in "Programs and Features" or "Apps & features."
• You can also use a Powershell script to verify: #verify-the-versions-of-msoledbsql-provider-installed

Test Expectations

• Launch Expectations and test its database connection.

Verify the versions of MSOLEDBSQL provider installed

Open up the 32 bit (x86) version of Powershell

​

Paste in the following script:

foreach ($provider in [System.Data.OleDb.OleDbEnumerator]::GetRootEnumerator()) {
    $properties = @{}
    for ($i = 0; $i -lt $provider.FieldCount; $i++) {
        $properties[$provider.GetName($i)] = $provider.GetValue($i)
    }
    [PSCustomObject]$properties
}

When you run the script a list of 32bit providers will be displayed. In that list look for a provider with:

SOURCES_NAME           :  MSOLEDBSQL

If the Provider does not show up then the 32bit (x86) version of the driver is not properly installed. If you see a provider named MSOLEDBSQL19 then you have installed the wrong version, see #id-1-install-oledb-drivers-1

Advanced Troubleshooting

• Install SQL Server Management Studio (SSMS): This may install missing dependencies or help diagnose connection problems.
• Contact Nexport Solutions Support: For persistent issues, contact support for expert assistance.