My company recently began testing new computers running Windows 7 64
bit. We have a custom application that runs SQL Anywhere 10.0.1 4075
(the cost current EBF). We use an ODBC System DSN to connect to the
database from a PowerBuilder application because multiple users often
share a machine. When we install we leave the 32 bit tools unchecked
(default).

The problem we're running into is that the system DSN isn't working
properly. Our application returns an ODBC error and when I try to
manually connect to the database using the ODBC in ISQL I get the
error "The specified DSN contains an architecture mismatch between the
Driver and Application".

Strangely enough, when I use a User DSN, the ODBC connection works
flawlessly. Has anyone run into this problem and been able to resolve
it? For us to deploy using User DSN instead of System would be a
logistical nightmare.

Thank you