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