search cancel

TDM: GT Datamaker 4.10.5.0 is unable to connect to the SQL Server 2019 Repository

book

Article ID: 243452

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After upgrading from TDM 4.9.1 to TDM 4.10, we noticed the GT Datamaker is not able to connect to the gtrep repository running on SQL Server 2019.

We tried reconfiguring the connection profile, thinking perhaps something was not saved, or changed with the upgrade. However, testing the connectivity through the Windows 'ODBC Data Source Administrator (32-bit)' dialog, we are able to successfully connect to the SQL Server 2019 database. However, when attempting to connect through Datamaker, we see the following error:

When testing the configuration profile through the 'Create connection profile for Test Data Repository' dialog, we see the following error:


We are able to access TDM Portal, and ARD is able to connect to the gtrep repository using the TDMService. We just cannot access gtrep via Datamaker for some reason.

Database Fatal Error Message: Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is not installed. (NOTE: the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) was installed even though this message appears.

Transaction Error Code: -1
Database Error Code: 999

CA Test Data Manager - Datamaker Details: GUI Version: 4.10.5.0 (Runtime: 21.0.0.1506) (5/15/2022 11:21:06)
Rep Version: 4.10.0.04

When testing the connection from the Windows ODBC (32-bit) dialog, the connection is successful. However, when testing it from within the 'Create connection profile for Test Data Repository, the connection fails with:

The connection details are valid BUT no CA Test Data Manager - Datamaker Test Data Repository tables were found.
Please make sure to install TDM Portal before Datamaker can be used....

Environment

Release : 4.10

Component : Datamaker

Cause

Needed to run Microsoft SQL Server patch.

Resolution

Running the attached patch resolves this issue.

Additional Information

33140061

Attachments

SQLServerOLEDriver-18.3_1654725416278.zip get_app