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 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

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



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: 01 Jul '15, 09:35

question was seen: 2,610 times

last updated: 01 Jul '15, 10:07