Problem connecting to Advantage Database, no tables

[AJgreenland]

I am trying to connect to an Advantage database on a remote server.  When I connect to the source none of the tables load into the query.

.

I can however access the tables using a SQL statement:

Any advice on getting the tables to show up without having to use SQL? Here is ODBC Driver Setup:

Thanks

AJ

[v-qiuyu-msft]

Hi @AJgreenland,

Please connect to the same DSN with same credential in Excel to see if tables are listed. If not, please go to Advantage database server, check if there are tables available for the account which you use to create the DSN. 

Best Regards,
Qiuyun Yu 

[AJgreenland]

@v-qiuyu-msft 

I can not access the tables in excel either.  I can access them in Advantage database Architect using the following properties:

 Here is the tracer log from trying to access using Power BI:

Tracer Log 

Thanks

AJ

[v-qiuyu-msft]

Hi @AJgreenland, 

I would suggest you also post a thread in Advantage Database Forum to check if you define the ODBC DSN correctly. 

Best Regards,
Qiuyun Yu