How to define a default dataset in ODBC driver

Question

I have a connection that connects bigquery with MS Access. I could link bigquery object's and view them in MS Access. But when I try to create a query by joining two tables, it shows an error:

ODBC-Call Failed
[simba][Bigquery][70] invalid query : Tablename 'tablename' missing dataset while no default dataset is specified in the request.[#70]

Below is the use-case ;-

I have got 2 linked table:

1. Table1
2. Table2

When I create a query via QueryDesign on table1 and on execution of the query I can see that data is fetched from bigquery and shown up in MS access. Similarly when I create an other query on table2, I could see the results.

But when I create a query via QueryDesing by joining table1 and table2, during execution of the join query, MS access throws the error below:

ODBC-Call Failed
[simba][Bigquery][70] invalid query : Tablename 'tablename' missing dataset while no default dataset is specified in the request.[#70]

Can someone help to configure the default dataset in ODBC?

Answer 1

Analyzing the issue, You will have 2 options:

1. Set the dataset on the odbc driver configuration:

• Follow the tutorial on this link to find the ODBC driver configurations.
• Set the default dataset name on this step, editing the user DSN:

2. If the probelm persists, then it will indicate an issue on the odbc simba connector.

• Open a issue case on issue tracker, so they can check you log details and provide a more appropriated support.