"Here is a trace of the error that I get.  I can see the tables and the fields but not the data.  Scribe says that the Flex ODBC driver is supported and compatible but can't determine fix.

Resuming trace for DataFlex AAIM -

11/13/2006 14:50:55 SQL> SELECT {fn NOW() }

ERROR!
   Error Number: 1005
   Native Error: 11013
   Source:       [FlexODBC]
   Description:  [42000] SQL call failed.  Unexpected end of SQL statement

Opening Recordset Query 5 on ACCOUNTS
   Options: FetchAll

11/13/2006 14:50:55 SQL> SELECT * FROM "ACCOUNTS"

Timer info (in seconds) for SOURCE: DataFlex AAIM -
141613.31: Total elapsed time
     0.75: Total db wait time
     0.01: Open recordset

11/13/2006 14:50:55 SQL>

11/13/2006 14:50:55 SQL>

Initializing Fields collection for Query 5

11/13/2006 14:50:55 SQL>

11/13/2006 14:50:55 SQL>

11/13/2006 14:50:55 SQL>

Timer info (in seconds) for SOURCE: DataFlex AAIM -
141613.45: Total elapsed time
     0.83: Total db wait time
     0.08: Get primary keys

ERROR!
   Error Number: 1005
   Native Error: 0
   Source:       [Microsoft][ODBC Driver Manager]
   Description:  [IM001] SQL call failed.  Driver does not support this function

Closing recordset Query 5

11/13/2006 15:15:33 SQL> SELECT {fn NOW() }

ERROR!
   Error Number: 1005
   Native Error: 11013
   Source:       [FlexODBC]
   Description:  [42000] SQL call failed.  Unexpected end of SQL statement

Opening Recordset Query 6 on ACCOUNTS
   Options: FetchAll

11/13/2006 15:15:33 SQL> SELECT * FROM "ACCOUNTS"

Timer info (in seconds) for SOURCE: DataFlex AAIM -
143091.56: Total elapsed time
     0.87: Total db wait time
     0.05: Open recordset

11/13/2006 15:15:33 SQL>

11/13/2006 15:15:33 SQL>

Initializing Fields collection for Query 6

11/13/2006 15:15:33 SQL>

11/13/2006 15:15:33 SQL>

11/13/2006 15:15:33 SQL>

Timer info (in seconds) for SOURCE: DataFlex AAIM -
143091.69: Total elapsed time
     0.95: Total db wait time
     0.08: Get primary keys

ERROR!
   Error Number: 1005
   Native Error: 0
   Source:       [Microsoft][ODBC Driver Manager]
   Description:  [IM001] SQL call failed.  Driver does not support this function

Closing recordset Query 6

11/13/2006 15:16:32 SQL>

11/13/2006 15:16:32 SQL>

Initializing Fields collection for TableDef: ACCOUNTS

11/13/2006 15:16:32 SQL>

11/13/2006 15:16:32 SQL>

Timer info (in seconds) for SOURCE: DataFlex AAIM -
143150.70: Total elapsed time
     1.03: Total db wait time
     0.08: Get field info

11/13/2006 15:16:33 SQL>

Timer info (in seconds) for SOURCE: DataFlex AAIM -
143150.72: Total elapsed time
     1.05: Total db wait time
     0.02: Get primary keys

Actual Totals for Database: DataFlex AAIM/    
Recordset Opens: 6, Seeks: 0, Inserts: 0, Updates: 0, Deletes: 0; Stored Procedures: 0

ERROR!
   Error Number: 107
   Native Error: 0
   Source:       ADP
   Description:  Data source label SOURCE not found.

Timer info (in seconds) for Test -
     0.38: Total elapsed time
     0.38: Total db wait time
     0.38: Open database (>=0.25)

SELECT {fn NOW() }

is invalid, this is ok:

SELECT {fn NOW() } from accounts

SELECT {fn NOW() }, name from accounts

Try using VB Demo to explore what tables are available to use.

I tried the following in VBdemo and it worked.

SELECT * FROM COMPANY

Same thing in Scribe produced the following error

11/13/2006 16:48:13 SQL> SELECT * FROM COMPANY

Timer info (in seconds) for SOURCE: DataFlex AAIM -
   635.59: Total elapsed time
     0.58: Total db wait time
     0.01: Open recordset

11/13/2006 16:48:13 SQL>

11/13/2006 16:48:13 SQL>

Initializing Fields collection for Query 7

ERROR!
   Error Number: 1005
   Native Error: 0
   Source:       [Microsoft][ODBC Driver Manager]
   Description:  [IM001] SQL call failed.  Driver does not support this function

Closing recordset Query 7

I tried the dll fix, but still had the same problem.  Even tried rebooting the server.