ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 132550


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Facing error while connecting to TDMMart profile from Datamaker locally. 

Cannot connect using supplied values. 

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


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.


Component: TDMDTM


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: 
   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.