In Pipeline Pilot 2021, I am finding a strange behavior on the Admin portal when defining a new data source to a SQL Server database using ODBC. When I try to add a data source to SQL Server using Type=ODBC (PP) and Driver Version=Latest, I consistently get an error message as shown below, with "Data source name not found and no default driver specified," even though this works in Pipeline Pilot 2018.
If I switch to using Driver version "7.1" instead of "Latest", it successfully connects. I am getting a few strange behaviors, however.
1) The Driver Version "7.1" would suddenly disappear from the dropdown box. To get it to display again on the GUI, I have to select another database type (e.g. Oracle), then re-select SQL Server to get "7.1" to become an option again.
2) When I can select "7.1" and hit save, the "saved" version will be "Latest" and not "7.1." I have been able to get it to save and retain "7.1" only after a series of testing the passwords and resetting multiple times. Unfortunately, I have not been able to replicate a process that saves successfully each time.
3) When I add a new SQL Server ODBC data source, all the previously registered SQL Server ODBC data connections using "7.1" would be converted to "Latest" and they would all fail. When I "fix" one ODBC data source from "Latest" to "7.1," all other data sources would revert back to driver version "7.1" Unfortunately, I have to do this each time I add a new data source!
The Pipeline Pilot 2021 server is running on Windows Server 2019. Is there a way to fix or bypass this issue?