Hi

Having installed the update to SQL Anywhere 17.0.4.2129, I notice a difference in unloading a database. Up to version 17.0.4.2066, I was able to execute the dbunload statement in the Summary page of the Unload Database Wizard directly by pressing the Finish Button. After the update, I get the attached error.

The dbunload statement looks like: dbunload -v -c "UID= testdatabase;PWD=***;Server=skyserver;DBN= Testdatabase;ASTART=No;host=10.0.1.2:2638" -an "/Users/admin/Desktop/Testdatabase.db" -ap 4096 -ea None -kdi 0 -ii -up

If I execute the very same statement in the terminal AND put at PWD= the password in clear instead of the ***, it works. As I think we have not changed the server environment (may be except an update of Java), I am wondering if there is a change in SQL Central?

  • OS X 10.11 El Capitan
  • Java 1.8.0_101

Best regards, Robert

alt text

asked 21 Oct '16, 08:08

robert's gravatar image

robert
543253445
accept rate: 0%

edited 21 Oct '16, 08:10


The generation of the unprocessed.sql file hasn't changed AFAIK. unprocessed.sql will go into the 'current directory'. Perhaps the current directory for your invocation of SQL Central is a location where you do not have write permission?

permanent link

answered 21 Oct '16, 10:12

John%20Smirnios's gravatar image

John Smirnios
8.8k377108
accept rate: 40%

Hi John I write the database as before the update to the admin's Desktop folder. As I am logged in as admin, I have write access to this folder. I am a little helpless what it could be.

(23 Oct '16, 06:31) robert
Replies hidden

Try changing the current directory of the SQL Central process. To do so, edit the icon that you use to invoke it. Right-click on the icon, choose 'Properties' then put a directory into the "Start in:" field.

(23 Oct '16, 07:57) John Smirnios

Do you mean the icon of SQL Central?

(25 Oct '16, 11:56) robert
Replies hidden

Yes. And you must restart SQL Central after editing the icon.

(25 Oct '16, 12:28) John Smirnios

I am on OS X and with Get Info I don't have a field like Start in:. I also checked Package Contents but can't find something like you mention. Could you give a hint where to find this field in El Capitan, please?

(26 Oct '16, 02:20) robert
Your answer
toggle preview

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

Question tags:

×40

question asked: 21 Oct '16, 08:08

question was seen: 167 times

last updated: 26 Oct '16, 02:20