I tried via MS Access SAS ODBC works !

But from WebFOCUS 5.2.5:

0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1

0 NUMBER OF RECORDS IN TABLE= 5 LINES= 5

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
: [S1000] [SAS][SAS ODBC Driver][SAS Server]ERROR 22-322: Expecting a name
: . [S1000] [SAS][SAS ODBC Driver][SAS Server]ERROR 202-322: The option or
: parameter is not recognized and will be ignored.
(FOC1406) SQL OPEN CURSOR ERROR. : SK_CALLS_20040601


Many thanks,
Pranas

Resolved:
Manual mofifications for ACCESS file is needed

I think creation of master from WFServer management Console should be improved.

Pranas