We use an ODBC Connection string to connect a SQL database pulling in demographic data from our Oracle student record system. We just upgraded our PeopleTools and changed to a higher version of the Oracle driver which was the only change. The connection string was as follows:
DRIVER=Oracle in instantclient_11_2; SERVER=OLDNAME; uid=XXXXXXX; pwd=XXXXXX; DBQ=XXXPROD
And changed to this new ODBC connection string:
DRIVER=Oracle in instantclient_12_1; SERVER=NewNAME; uid=XXXXXXX; pwd=XXXXXX; DBQ=XXXPROD
But when I trying testing the above connection string, I get the following error message:
Client import test failed. Failed to connect to external datasource with the given ODBC connection string.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.