Chapter 8: Solve Connection and Import Problems
Check the Driver, Ports and Login Before Retrying
| Symptom | Action |
|---|---|
| The DSN is missing | Match the client and driver bitness; use SysWOW64\odbcad32.exe for these 32-bit clients. |
| A connection waits or fails | Check the gateway's actual listener and the client's sqlnw mapping. |
Login returns -1016 Can't Connect to the Appx Data Server | Check credentials, the APPX login-manager service and APPX_DATA_SERVER in appx.env. |
| Windows cannot start ASQL or the gateway | Check the full loader error and the matching Microsoft runtime family. |
| A table is not found | Check the selected dictionary and import the individual COUNTRY definition. |
| Access import fails | Use the verified 5.5.3 Access configuration or this edition's Excel, Base direct SQL or PowerShell procedure. Repeated Access imports did not fix this edition. |
| An import stops partway through | Save the full SQL and error and review the wide-file guidance. |