The data source test will fail if the Shared memory is checked

If you are running a SQL Anywhere network server engine (for example, using dbsrv11.exe or running a network service), then the ODBC DNS cannot have Shared memory checked or else the data source test will fail.

Figure 88. Shared memory caused error

Shared memory caused error

Solution: Uncheck the Shared memory checkbox on the Network tab.