I am trying to connect to a Oracle database in house with Datalink. I have used the Datalink wizard, selecting OBDC and SQL options. When asked to test the connection with a user name and password, I get a ‘Test Successful” message. The next step of wizard basically calls for the re-entry of the same user name and password. When I do this I get an error message stating:
“Connection failed: java.lang.RuntimeException:
com.subx.general.data.core.iapi.jdbc.JDBCConnectionException: Connection canceled by user.”
I cannot get any further into the Datalink Wizard. What should I be looking at to resolve the error received? Any help appreciated.