I'm running into issues trying to Add a User DSN. When creating a DSN, I continue receiving an error after entering in my Login ID and password. Has anyone ran into this issue and know how to resolve it?
I continue receiving an error
How To Ask Questions The Smart Way
I receive a [nQSError:12017] Unexpected socket read timeout: connection terminated by network. I also receive a [nQSError:12008] Unable to connect to port on machine.
Your OBIEE server isn't running, or you've not put the correct server details in for your DSN.
Make sure your Oracle DB is running on the specified port. You can always check by running following command on cmd prompt
TELNET <DBSERVERNAME> <DBPORT>
This shows first if the port is open between the machine you are trying to setup DSN to the Oracle DB.
If it enters a blank page that means the DB is up and running and ports are connecting.
If you're setting up an Oracle BI DSN, you don't want to be putting the Oracle DB port in there - that *will* throw an error
