Have a working VB ASP application. For reasons of being able to share code between this platform and several batch environments, I want to have an I/O program which is written in COBOL and accesses databases using ODBC.
In the batch environment, I wrote a caller and had no problem. The I/O program refers to a data source name defined in ODBC.Inf. It knows where to find ODBC.Inf by virtue of the @ODBC_INF environment variable.
However, when the VB ASP application calls the same program (in the .Net environment), the COBOL's
"EXEC SQL CONNECT TO 'TAIPROD' END-EXEC"
returns with "Data source name not found and no default driver specified".
Because the same program is connecting in the batch environment, I think it's a fair assumption that the problem is that when the COBOL program is called by the VB ASP program it cannot find ODBC.Inf.
The .Net COBOL help tells how to put
<add key="@ODBC_INF" value="C:\ODBC.INF"/>
into Web.Config, but I believe that only an ASP COBOL program will know to look there (I tried putting this information in Web.Config, App.Config, and Machine.Config to no avail).
Any suggestions on
1. how to specify where ODBC.Inf resides
2. how to actually see the process happening - I am really blind-guessing here, all I get is the consistent "Data source name not found and no default driver specified" message on the connect, with no way of knowing if it looked for ODBC.Inf, if it found it, etc.
In the batch environment, I wrote a caller and had no problem. The I/O program refers to a data source name defined in ODBC.Inf. It knows where to find ODBC.Inf by virtue of the @ODBC_INF environment variable.
However, when the VB ASP application calls the same program (in the .Net environment), the COBOL's
"EXEC SQL CONNECT TO 'TAIPROD' END-EXEC"
returns with "Data source name not found and no default driver specified".
Because the same program is connecting in the batch environment, I think it's a fair assumption that the problem is that when the COBOL program is called by the VB ASP program it cannot find ODBC.Inf.
The .Net COBOL help tells how to put
<add key="@ODBC_INF" value="C:\ODBC.INF"/>
into Web.Config, but I believe that only an ASP COBOL program will know to look there (I tried putting this information in Web.Config, App.Config, and Machine.Config to no avail).
Any suggestions on
1. how to specify where ODBC.Inf resides
2. how to actually see the process happening - I am really blind-guessing here, all I get is the consistent "Data source name not found and no default driver specified" message on the connect, with no way of knowing if it looked for ODBC.Inf, if it found it, etc.