Getting error "Permission denied: you do not have permission to select from “DUMMY”

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.

sa-5

asked 24 Nov '11, 01:27

SHRIKANT SQL...
16●1●1●2
accept rate: 0%

edited 24 Nov '11, 08:06

Justin Willey
7.6k●137●179●249

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Willey
7.6k●137●179●249
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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

sa-5 ×17
login ×15

question asked: 24 Nov '11, 01:27

question was seen: 35,908 times

last updated: 24 Nov '11, 08:51

SAP SQL Anywhere

Getting error "Permission denied: you do not have permission to select from “DUMMY”

Follow this question

Related questions