Datamaker Profile Error - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Facing error while connecting to TDMMart profile from Datamaker locally. 

Cannot connect using supplied values. 

Connection: Data Source 
Profile: TDMMART 
odbc: 999 
SQLSTATE = IM002 
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. 

Environment

TDM 
Test Data Manager
DataMaker

Cause

The ODBC driver associated with the TDMMART[*] profile is not on the machine. 

Brought up the ODBC Data Source Administrator (32-bit), choose the Drivers tab, scroll down and verified that SQL Server Native Client 10.0 is not on the machine.
The only SQL Server Native Client driver is version 11.0.
The machine had been updated and no longer had the 10.0 driver.

Resolution

Needed to update the Profile TDMMART[*] to use SQL Server Native Client 11.0. 

1. Choose Test Data, 
2. Choose Test Data Repository SQL Window 
3. Expand the Tables 
4. Scroll down till you get to the gtrep_profile table. 
5. Do a select on the profile table for that profile: 
SELECT * FROM 
   dbo.gtrep_profile where prof_name = "TDMMart' 
6. Two rows come back. 
7. Need to update the row that has a Prof Su ID of -1 
8. Change the column values that have {SQL Server Native Client 10.0} to have {SQL Server Native Client 11.0}. 
9. Save Data. 
10. Then able to connect to the TDMMART[*] profile with no errors.