In unixODBC 1.8.8 and earlier, isql and DataManager pass in a database username and password to SQLConnect
even if you do not specify them. isql takes two optional arguments after the DSN. These are the database username and database password. If you omit them, isql passes empty strings to the Easysoft ODBC-ODBC Bridge, which believes a username and password were specified and therefore doesn't pull the TargetUser
and TargetAuth
out of the DSN.
If your ODBC driver requires a username and password and you are using isql or DataManager, you must specify them either on the isql command line or in the DataManager dialog box, when prompted.