0 Replies Latest reply: Dec 20, 2012 11:46 AM by 981096 RSS

    Oracle connectivity problem via Cobol ODBC program

    981096
      Dear All,

      I am running a COBOL odbc program (odbc2eg.cbl) for Windows which is used to connect to Oracle database. All the calls in the program are rewritten using call identifier; one example is as shown below.

      Code:
      MOVE "SQLConnect" TO W-WK-PROGRAM-NAME
      CALL W-WK-PROGRAM-NAME USING BY VALUE Hdbc
      BY REFERENCE szDSN
      BY VALUE SQL-NTS
      BY REFERENCE szUID
      BY VALUE SQL-NTS
      BY REFERENCE szAuthStr
      BY VALUE SQL-NTS
      RETURNING SQL-RC

      The oracle environment is setup properly as 'SQLPLUS' command gives oracle dialog asking for username and password. The program is compiled using the below command.

      Code:
      cob2 -v odbc2eg.cbl

      It passes the compile and link-edit creates the odbc2eg.exe file. However I am getting run-time error at the above call statement as shown below.

      Sample ODBC 2 program starts
      IWZ096C Dynamic call of program SQLAllocEnv failed. The load module
      SQLAllocEnv.dll could not be found in the directories identified in
      the COBPATH environment variable.
      iwzrlib.dll : 0
      iwzrlib.dll : 0
      iwzrlib.dll : 0
      odbc2eg.exe : 0
      iwzrlib.dll : 0
      odbc2eg.exe : 0
      kernel32.dll : 0
      IWZ901S Program exits due to severe or critical error.

      The COBPATH environment variable points to library folder which contains the .lib files. There is no program named 'SQLAllocEnv.dll' and these are database related calls. Can anyone please help me out?

      Regards,
      Jay