WebFOCUS 4.3.6 run locally on NT desktop.
Oracle 9.2 installed

The acx file:
SEGNAME=ENTITYZ,
TABLENAME=COMPPROD.ENTITY_VIEW,
KEYS=1
,$

The master file:
FILE=ENTITYZ, SUFFIX=SQLORA ,$
SEGNAME=ENTITYZ, SEGTYPE=S0 ,$
FIELDNAME......etc.

Connection info:
SQL SQLORA SET USER -theid/thepw@compprod.compsys.com
END

I'm getting the following when trying to TABLE FILE ENTITYZ:

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1488) SQL INTERFACE IS NOT INSTALLED
(FOC1479) ERROR CONNECTING TO SQL DATABASE :

BTW, this worked fine when:
ACX file had the SERVER=COMPPROD parameter
MAS file had SUFFIX=SQLODBC
Connection info was:
SQL SQLODBC SET USER COMPPROD/theid,thepw
SQL SQLODBC SET OPTIMIZATION ON
-RUN

Any ideas? Thanks!

Did you set an Oracle data adapter from the WF Console? Did you set up a connection to your database?

So, is there something I have to do that I didn't have to before (when using ODBC)?

Yes. You have to configure the Oracle data adapter and add a connection to the database you want to access.

The I would use the WF Console to generate the meta-data (MAS and ACX), I would never code them myself.

Makes sense, but I'm on 4.3.6

I can't remember that far back, but it should be the same.

Our current Prod 4.3.6 environment runs with server version 5.1.6.

BTW, this is standalone 4.3.6 (no EDA).

I did find the solution, guided by your suggestions.

Went to WebFOCUS Desktop Utilities > Set Up Access To Relational Databases > Checked ORACLE.

Thanks!