The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
543253345
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.7k377106
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:

×37

question asked: 21 Oct '16, 08:08

question was seen: 136 times

last updated: 26 Oct '16, 02:20