On 2014-01-06 21:26, rohan.henry @cwjamaica.com wrote: Thanks Alexander.
I am able to connect to the remote server via the Linux prompt using: sqlplus user/passwd@server_IP/SID But can't seem to get it right in Radiator. Rohan On Fri, Jan 3, 2014 at 5:24 AM, Hartmaier Alexander <[email protected]<mailto:[email protected]>> wrote: On 2014-01-03 00:14, rohan.henry @cwjamaica.com<http://cwjamaica.com> wrote: Hello, How is a non default port specified when connecting to a remote Oracle server? Thanks. DBSource dbi:oracle:server DBUsername DBAuth Rohan The Oracle InstantClient configuration is in tnsnames.ora, there you specify things like hostnames, ports and other settings. In Radiator you only use the name you gave the connection in tnsnames.ora. The DBD::Oracle docs show you the possible ways to connect: https://metacpan.org/pod/DBD::Oracle#connect Normally you'd specify the database name you've defined in tnsnames.ora: DBSource dbi:Oracle:DBNAME Note that Perl is case sensitive, you have to specify Oracle uppercase else DBI looks for a DBD::oracle module. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
