Skip to main content

Problem:

How to perform Implicit Connection to a MS SQL database from a COBOL program in Net Express 4.0?

Resolution:

'Database Access' book > 'Part 2: OpenESQL' > '7: OpenESQL'

Create an ODBC data source to the MS SQL database and test the connection.

Set the SQL directives INIT, DB (name of the ODBC data source) and PASS (username.password to access the database)

Example - $set SQL(INIT DB=mydatasource PASS=username.)

Micro Focus recommends that rather than using the SQL(INIT) compiler directive, that EXEC SQL CONNECT statements be used instead.

Old KB# 1258