Error with Oracle ODBC Connection String

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.

0 answers