DataLink Issues

3.97K viewsDataLink

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: 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.