Connectivity from NT to Oracle on HP UNIX

[SenMerc]

Hi,

Having trouble running map on NT machine, and kicking off an Oracle Function/Stored Procedure, on an Oracle database residing on an HP Unix platform.

The scenario is the following:

Trying to hit Oracle procedure from rule in output card using DBLOOKUP, and unable to connect to Oracle instance on HP Unix box.

I have an mdq file set up, and it is able to read tables/procedures from Database on the HP box.

Here is the output card map rule:

DBLOOKUP("begin F_WORKHOURS('STRING'); end; " , "-MDQ C:/tmp_prj.mdq -DBNAME SOMETHING -USER CC -PASSWORD DD")

The database trace has the following:

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\PROGRA~1\MERCAT~1.7\MapEdit.exe)(HOST=XXXXXX)(USER=XXXXX))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 22-DEC-2005 10:45:55
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 126
nt OS err code: 0


Any assistance would be greatly appreciated.

Thanks,

 

[SenMerc]

Found problem, please disregard.

Thanks,