Hi Guys

This one took me a while to figure out, but here we go:
Multiple databases on the server.
Lets call the data1 and data2
19.1 Studio with DFConnId.ini
ODBC linked to MariaDB 3.1 driver, MariaDB server AND database name 'data2'
CCH is turned off at the driver level (and no cch is created)

The int is linked to the dfConnId linked to the odbc linked to data2

Open a table (filelist or open as; no difference detected).
The table is present in both database data1 and data2, however the definition (columns) differ.

Zerofile, and other commands are done on the correct table in data2
However the following commands show the details of the table with the same name of data1
Code:
Integer iCol iCols
String sName
Get_Attribute DF_FILE_NUMBER_FIELDS of iTableSQL to iCols
For iCol from 0 to iCols
    Get_Attribute DF_FIELD_NAME of iTableSQL iCol to sName
    Showln sName
Loop
It turned out, if I rename data1 to data9 then it queries data2.

Conclusion;
These (and probably more) get_attribute commands, query the first table on the server that matches the name (order by database name).
It does NOT take the database name as specified in the odbc connection into account, as the zerofile etc.

Unbelievable right... but its true

Kind regards
Marco