Skip to main content

MS Access DCLGEN

  • February 16, 2015
  • 1 reply
  • 0 views

Can someone walk me through how to setup a MS Access (accdb) DB to use with VC and how to create a DCLGEN.

I have been at this for about 2 months with no luck.


#databases
#DCLGENAccess

1 reply

Chris Glazier
Forum|alt.badge.img+2
  • Moderator
  • February 17, 2015

Can someone walk me through how to setup a MS Access (accdb) DB to use with VC and how to create a DCLGEN.

I have been at this for about 2 months with no luck.


#databases
#DCLGENAccess

To access any database including MS Access from within a native Visual COBOL program you will need to create an ODBC DSN in order to connect to the database. You can then use this DSN in your EXEC SQL CONNECT TO statement in your program and then issue other EXEC SQL I-O statements against it. The OpenESQL Assistant tool can be a great tool to help you get started.

The following videos may be useful to you:

Using ODBC with Visual COBOL
OpenESQL Database Connections
OpenESQL Assistant

Thanks.