The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

hi all,

i am trying to migrate a db(created using sqlanywhere 5.0 or lesser). when i execute below from sybase central 12. i get below error.

dbunload -c "dbn=D:\Quartz32_Iteration3.0_old\DB\qz98;uid=DBA;pwd=SQL" -n c:\temp

sqlcode=-131,odbc3 state ="42000"

asked 01 Jul '15, 09:35

muruganand's gravatar image

muruganand
44333
accept rate: 0%

The error is a generic "Syntax Error" so does not provide enough information to determine the cause of the problem.

Are you trying to execute the "dbunload" command in the Sybase Central (SC) window? If so then you need to realize that dbunload is not a SC command but is a program that needs to be run from a shell/command prompt.

(01 Jul '15, 10:03) Mark Culp

FWIW, moving from v5 (or even older) to v12 is a huge step - cf. that doc page with some hints to possible problems.

The error should also contain a description, such as "Syntax error near ..." that might give a further clue - it might be that your old database is using a word as identifier which is nowadays a reserved word and treated differently when parsing SQL statements...

(01 Jul '15, 10:07) Volker Barth
Be the first one to answer this question!
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:

×35

question asked: 01 Jul '15, 09:35

question was seen: 1,042 times

last updated: 01 Jul '15, 10:07