How to specify non-standard port for Oracle OLEDB connection?
Hi all. I'm connecting to an Oracle database that's on a non-standard port. I'm using the "Oracle Provider for OLE DB" and entering the connection info in the Data Link Properties window inside the QlikView script editor. What do I need to do to specify a different port? I put in the connection info, and I get this error:
Microsoft Data Link Error: Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified