I am new to SQL anywhere and we have very old SQL anywhere instance Version 5. We use DSN to connect to this server/database but when tried to connect getting error Permission denied: you do not have permission to select from “DUMMY”. This looks like permission error but its not allowing me to connect to check or rectify. How can I connect to this server now , I don't have any other DSN or userid password. Thanks for any help on this.
In order to get an error message like that, it sounds like you are in fact getting connected, but using a user id that has insufficient rights for your purpose. You may be able to get a better idea of what is going on by logging the connection activity, either through turning on ODBC trace or through the SQL Anywhere client (not sure how to do that in v5 - its probably an option on the dbclient.exe maybe -z & -o from what I can remember).
Have you tried connecting using default UID / PWD : dba / sql ? You could create a new DSN to use those.
If that doesn't work, you may need paid for support to salvage the data.
answered 24 Nov '11, 08:05