Proto Software

I am trying to connect to an Access database using the ODBC module. Here are the steps I'm using:

1) Add ODBC and Table modules to the builder.

2) Configure ODBC with same connection string as example, only switching out the path of the Northwind DB with the one I want to connect to ("C:\Northwind.mdb" for "D:\Deposits\Deposits.mdb").

3)Copy/paste SQL from the query designer in Access.

4) Connect from 'ODBC Connectors > Get Data' to 'Table Connectors > Set Entryset'.

Based on what I saw in the Introduction demo, I should be able to see some data at this point in the entryset data viewer, or in the table, but I'm not getting anything.

Just to check that I was using the right connection string, I copied and pasted the connection string & SQL into a module in Excel, and made an ADODB connection to the database without any problems.

Am I missing a step in Proto?

Hi -

Interesting that you didn't get an error, it simply did nothing?

After creating the setup described above from the ODBC to a Table, will you try connecting a Button to the input "Do Refresh Data" and then click the Button in the Viewer? That should force the connection string and query to refresh.