how a CGI program knows where is the Access data base in a web server ?

hello,

I use Netexpress 2.0.

I need to make a web page accessing 'Microsoft Access data base' in a web server (Windows x IIS).

I have studied the manuals and searched on the internet for finding out how to do this.

My first question is:

How a CGI program knows where is the Access data base in a web server ?

Can someone help me, please ?

thanks in advance

Lima

Net Express 2.0 is a very old product and hasn't been supported in a very long time.

In native COBOL you would use ODBC to connect to the database.
You would use the Windows ODBC Data Source Administrator tool to create a DSN that points to your database. In the COBOL program you use the embedded SQL statement:
    EXEC SQL CONNECT TO "dsn-name" END-EXEC

Once the connection is established you can issue other embedded SQL statements against the database.

There should be samples on how to do this in the samples folder, although NX 2.0 is so old I do not remember exactly where this would be.

hello Chris,

Thank you for the answer.

I have already tested a solution with odbc, but locally, I mean, using a LAN.

But, I need to put the database and the program in a remote web server (WAN). In this case, should I create the odbc connection in the remote web server ?

Regards.

Lima

Yes, you would still use an ODBC connection but it would be configured on the web server on which the application is running. You start this application by accessing a URL from another computer that will then communicate with the web server using http and the web server will run your application. You must be able to connect to the database from the web server machine.