SQL Anywhere 10.0.1 build 3504 + Access 2007 ODBC connection -
11-02-2007
, 07:19 AM
On a Vista workstation I've tried to update the ODBC setting
from an existing Access 97 database that was previously
linked to the old iAnywhere database using the 9.0.2 driver.
In some instances the settings for the ODBC connection
appear to stay but in others I need to reset the Server
name(we've changed the name of the database server as we
upgraded). Admittedly I may need to do more testing; but
I'm not sure if it is a 'link manager' issue in Access or
SQL Anywhere driver setting that I need. Don't know if this
makes a difference, we are using roaming profiles.
At this time, we have the 'live' connection just set up for
a week; the main application seems to connect fine using the
ODBC settings. |