Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hi ,

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.

asked 24 Nov '11, 01:27

SHRIKANT%20SQL%20ANYWHERE's gravatar image

accept rate: 0%

edited 24 Nov '11, 08:06

Justin%20Willey's gravatar image

Justin Willey

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.

permanent link

answered 24 Nov '11, 08:05

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

DBClient.exe Syntax

dbclient [switches] server-name

Windows 3.x syntax

dbclienw [switches] server-name

Switch Description starting communication links

starting communication links > -b max-packets Set the maximum number of packets for multi-row fetches

-c Purge previous connections
-e Encrypt all network packets
-ga Automatically shut down after last connection closed
-o filename Output messages to a file
-p packet_size Set maximum network packet size
-q Quiet mode—suppress output
-r Disable multiple-row fetching
-s buffer_space Memory for buffers in K
-ta sec Scan time for terminated applications:—default 30 seconds
-tl seconds Client liveness timeout in seconds—default is server setting which defaults to 120 seconds
-ts t1[,t2] Client min [and max] retry time in 100ths of a second
-x list Comma separated list of communication links to run, with any parameters
-y Start with no server connection
-Z Provide diagnostic information when starting communication linksstarting communication links

(24 Nov '11, 08:14) Justin Willey
Replies hidden

SQLAnywhere version 9 can read version 5 database files. It might work better and/or provide better diagnostics.

(24 Nov '11, 08:51) John Smirnios
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 24 Nov '11, 01:27

question was seen: 36,087 times

last updated: 24 Nov '11, 08:51