Microfocus Netexpress question : COBSQL vs openESQL

From: chris bougeard (sihingchris_at_hotmail.com)
Date: 09/09/04 

Date: 9 Sep 2004 07:10:18 -0700

Hi everyone,
On the site i am working on, i am in the process of converting a bunch of
pro*cobol programs which currently sit on a unix platform/oracle database
to work in a windows environment.

Im using a development machine (windows 2000) with netexpress 3.1 to test
how these programs work once regenerated.

When it came to the issue of pre-compiling the embedded sql statements, i
first tried using the COBSQL method but my compiles always fell over...

However, by using the openESQL approach, my compiles were all clean and the
programs connect to the database and retrieve data fine...

First question, is it better to use the ORACLE supplied pre-compiler (which
generally misbehaves) over the openESQL (which works fine) in order to
reduce the chances of sql anomalies during run time?

Is it strange that i didnt have to load anything specifically on my machine
in order for openESQL to work (im sure i have read that certain drivers etc
must exist).

I recently tried to run a program compiled on my windows2000 box on an nt4
machine , the program ran (after installing application server on it) but
couldnt connect with the oracle database specified in the program.

Could this just be down to the fact that the nt4 box is missing a dll or
something or is there perhaps a more sinister possibility?

I actually tried today to re-compile this program using COBSQL, its
failing with CSQL-E-036 "unable to open the precompiler file
"filename".cs9".

Dont suppose you have any ideas on this one ?

Sorry to be a pest, just a couple more questions :

WHERE do i put the compiler directives when using COBSQL?

Is "application server" just simply a set of run time dll's that you need
user licenses for to run cobol apps?

I presume it doesnt run as a service...

Sorry for so many questions,

hope to hear from you,

chris

==========================================================================

Relevant Pages

  • Re: Microfocus Netexpress question : COBSQL vs openESQL
    ... that I wish I had used OpenESQL instead of Pro*COBOL. ... release of Oracle manages to break something in Pro*COBOL that has some ... > first tried using the COBSQL method but my compiles always fell over... ...
    (comp.lang.cobol)
  • Re: Do header files really serve a useful purpose?
    ... > Long compiles would be a thing of the past, immediate access to symbols, ... > functions, classe, etc. would be available in the editor. ... > I'm amazed that new language after new language continues to use the bad old ... database that's hidden behind some GUI. ...
    (comp.lang.cpp)
  • Re: TclKit, create standalone EXE, add Tcl library to Executable, Tcl_FSRegister?
    ... > i can create a C file that compiles and links against ... > and adds each file it finds to a database. ... Linking Tcl ... and specifically which libraries you're linking when it can't find ...
    (comp.lang.tcl)
  • Re: PostgreSQL/Eclipse/Tomcat - How to connect to DB?
    ... In eclipse it's the standard behaviour that code compiles always ... > the Postgres tools to create the database you want to use before you can ... said "Unhandeled exception type ClassNotFoundException" at the forName ...
    (comp.lang.java.programmer)
  • Re: Looking for database that is easy to install
    ... Absolute Database from http://www.componentace.com is a single-file database and ... It's easy to install as it compiles right ... ComponentAce - database, compression and encryption components ...
    (borland.public.delphi.thirdpartytools.general)