I am trying to Create New Internet App in Netexpress, which usually work well. This CBL has embedded SQL in it and the Create gives me error message NO SQL DIRECTIVES have been set. The directives I have Set are DBMAN (ODBC), AUTOCOMMIT, ALLOWNULLCHAR. Do I need others?
Ellen S.
Hello Ellen,
Where did you set the SQL directives? Is it in COBOL.DIR, project directives, or in the source code?
In the source code, you would set them right after the htmlpp one:
|
$set preprocess(htmlpp) endp $set sql(dbman=odbc, ...)
|
Regards,
I am trying to Create New Internet App in Netexpress, which usually work well. This CBL has embedded SQL in it and the Create gives me error message NO SQL DIRECTIVES have been set. The directives I have Set are DBMAN (ODBC), AUTOCOMMIT, ALLOWNULLCHAR. Do I need others?
Ellen S.
I set the SQL directives in project directives
I am trying to Create New Internet App in Netexpress, which usually work well. This CBL has embedded SQL in it and the Create gives me error message NO SQL DIRECTIVES have been set. The directives I have Set are DBMAN (ODBC), AUTOCOMMIT, ALLOWNULLCHAR. Do I need others?
Ellen S.
I set the SQL directives in project directives
I am trying to Create New Internet App in Netexpress, which usually work well. This CBL has embedded SQL in it and the Create gives me error message NO SQL DIRECTIVES have been set. The directives I have Set are DBMAN (ODBC), AUTOCOMMIT, ALLOWNULLCHAR. Do I need others?
Ellen S.
That should be fine to set them there unless they are being turned off at the program level.
Check your project directives to ensure that you don't have a semi-colon character unintentionally delimiting your directives. Perhaps it isn't being picked up.