Choose Oracle Client as a driver when you creating a DSN.
Step1 : Goto Script Editor and click Tools Menu under that choose ODBC Administrator 64-bit/32-bit.
Step2 : Go to System DSN click on Add button.
Step3 : Chosse the Oracle Client Driver from list
Step4 : Give DSN Name and Server Name, user credentials click on Test Connection and click ok
Step5 : Come to Script editor click on connection choose the DSN and provide the user credentials and click on Test connection. Automatically it establish the connection string after that click on select to read the Tables.