PDA

View Full Version : ODBC connection when using Advantage SQL


sam.otago
March 29th, 2020, 04:51 PM
We were previously using ODBC v8.1 32-bit, because we weren't using the Advantage SQL service, and that worked fine.

However, we recently upgrade to Advantage SQL. I thought it might just be a case of updating to v11.10 of the ODBC drivers, but even with those, I am getting a 7008 error when trying to query tables:
"The specified table, memo file, or index file was unable to be opened"

Is there anything else that I would need to change/update?

sam.otago
March 29th, 2020, 07:48 PM
Got it. Previously we used "Local Server", now it seems to require "Remote Server"