Skip to main content

configuration to connect to oracle

  • February 17, 2014
  • 4 replies
  • 1 view
D

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.0

4 replies

Chris Glazier
Forum|alt.badge.img+3
  • Chris GlazierModerator
  • Moderator
  • February 18, 2014

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.0

There 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.

D

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.0

Thanks a lot  Chris Glazier..

   I'll  try the things that you suggested and come back.

D

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.0

Thanks a lot  Chris Glazier..

   I'll  try the things that you suggested and come back.

D

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.0

Thanks a lot  Chris Glazier..

   I'll  try the things that you suggested and come back.

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement