RE: Error 173 called program file not found in drive / directory SQLADR with Oracle 11g
I have a solution and multiple projects under it. Some of the projects(they have one program) call another one that has with multiple programs within it.
Say there is A with program a, B with program b, and C with program c and they are separate projects with only one program. Then, there is Project Z with programs 1, 2, 3, 4, 5, 6 in it.
A is an older project and it calls programs from Z. When I animate through it and through them, there is no problem with the SQL
B is a new project with the same (presumably) properties as A. However, when I animate B, the first SQL stmts in program b work (connect to database), but then when I try to do a ROLLBACK, I get this message that SQLADR can't be found. If I comment that out and call programs in Z, when I get to an SQL statement, I get the same error.
These are the stmts at the start of program a of project B and they work fine.
EXEC SQL CONNECT
and this does
EXEC SQL ALTER SESSION
SET NLS_DATE_FORMAT = 'MM-DD-YYYY'
This, also in program b, does not.
EXEC SQL ROLLBACK END-EXEC.
The preprocessor directives for project B are (same as for project A)
P(cobsql) COBSQLTYPE=ORACLE END-COBSQL ENDP
Not sure WHAT could be wrong.....