Three common issues when trying to set up data source connections to the Enterprise View.

Problem

I am trying to execute a Clementine\Modeler stream that uses an Enterprise View node to access a database through PES. Sometimes I see these errors: Error 1: Connection not open and Unable to locate data source defined in DPD errors 08003 [Microsoft][ODBC Driver Manager] Connection not open HY000[-1] [SPSS PEV Driver] Unable to locate data source defined in the DPD Failed to connect to datasource: DRIVER=SPSS PEV Driver;PEV.HOST=testserver1;PEV.PORT=8080;PEV.AV=/Test/testfolder/Test_Info;PEV.ENV=analytic;PEV.DPD=/testserver1/testfolder/TestInfo_DPD;PEV.LABEL=LATEST;UID=admin;PWD=***** Error 2: Error: IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error: Failed to connect to datasource: DRIVER=SPSS PEV Driver;PEV.HOST=SPSSPES01.USAC.MMM.COM;PEV.PORT=8080;PEV.AV=/IT-Corporate/Business-Intel/avw_ct01;PEV.ENV=analytic;PEV.DPD=/IT-Corporate/Business-Intel/dpd_ct01_01;PEV.LABEL=LATEST;UID=a09zmzz;PWD=***** Information: Stream execution complete, Elapsed=0.49 sec, CPU=0.0 sec or Failed to connect to datasource: DRIVER=SPSS PEV Driver;PEV.HOST=testserver1;PEV.PORT=8080;PEV.AV=/test/testfolder/Test_Info;PEV.ENV=analytic;PEV.DPD=/test/testfolder/TestInfo_DPD;PEV.LABEL=LATEST;UID=admin;PWD=***** Error 3: Received Error SQL Table not found (SPSS_PEV.customers)