Hi
I'm a newbie to COBOL and netexpress
I have installed netexpress 5 and oracle 11g XE on windows XP OS. I need to write small programs like getting data from database and use it in the COBOL program. I'd like to know what are the things I need to configure,install to make connection b/w netexpress and oracle 11g
got some information like below.
environment variables
SET COBCPY=
SET COBDIR=
SET COBIDY=
SET DB_USRID=
SET DB_PASSWD=
in program
EXEC SQL
CONNECT :WSH-USER-INFO IDENTIFIED BY :WSH-PASSWD
END-EXEC.
many thanks
#oracle11gXE#NetExpress5.0There are two main methods of accessing an Oracle database from a Net Express program.
The first is to use the Oracle Pro*COBOL precompiler in conjunction with the cobsql technology of Net Express.
The second method is to use an Oracle ODBC driver in conjunction with the OpenESQL precompiler of Net Express.
Since you do not currently have a collection of existing programs that already use Pro*COBOL then I would recommend that you use the OpenESQL technology instead.
This is documented here:
Look at the example programs for OpenESQL in the following location:
C:\\Program Files\\Micro Focus\\Net Express 5.0\\Examples\\Net Express IDE\\ODBCESQL
You basically just have to create a DSN using the ODBC Administrator that points to your database and then you can connect to that DSN from within your program.
Thanks.
Hi
I'm a newbie to COBOL and netexpress
I have installed netexpress 5 and oracle 11g XE on windows XP OS. I need to write small programs like getting data from database and use it in the COBOL program. I'd like to know what are the things I need to configure,install to make connection b/w netexpress and oracle 11g
got some information like below.
environment variables
SET COBCPY=
SET COBDIR=
SET COBIDY=
SET DB_USRID=
SET DB_PASSWD=
in program
EXEC SQL
CONNECT :WSH-USER-INFO IDENTIFIED BY :WSH-PASSWD
END-EXEC.
many thanks
#oracle11gXE#NetExpress5.0Thanks a lot Chris Glazier..
I'll try the things that you suggested and come back.
Hi
I'm a newbie to COBOL and netexpress
I have installed netexpress 5 and oracle 11g XE on windows XP OS. I need to write small programs like getting data from database and use it in the COBOL program. I'd like to know what are the things I need to configure,install to make connection b/w netexpress and oracle 11g
got some information like below.
environment variables
SET COBCPY=
SET COBDIR=
SET COBIDY=
SET DB_USRID=
SET DB_PASSWD=
in program
EXEC SQL
CONNECT :WSH-USER-INFO IDENTIFIED BY :WSH-PASSWD
END-EXEC.
many thanks
#oracle11gXE#NetExpress5.0Thanks a lot Chris Glazier..
I'll try the things that you suggested and come back.
Hi
I'm a newbie to COBOL and netexpress
I have installed netexpress 5 and oracle 11g XE on windows XP OS. I need to write small programs like getting data from database and use it in the COBOL program. I'd like to know what are the things I need to configure,install to make connection b/w netexpress and oracle 11g
got some information like below.
environment variables
SET COBCPY=
SET COBDIR=
SET COBIDY=
SET DB_USRID=
SET DB_PASSWD=
in program
EXEC SQL
CONNECT :WSH-USER-INFO IDENTIFIED BY :WSH-PASSWD
END-EXEC.
many thanks
#oracle11gXE#NetExpress5.0Thanks a lot Chris Glazier..
I'll try the things that you suggested and come back.
