Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Does anyone know how to fix a sql anywhere database with the following error:

[Sybase][ODBC Driver][SQL Anywhere]Specified database is invalid


asked 05 Jan '21, 04:06

VMeng's gravatar image

accept rate: 0%

The error description for SQLCODE -84 does not tell much. As you are using SQL Anywhere and have tagged with "advantage database server": Could it be you are trying to use SQL Anywhere to connect to resp. start an Advangage Database Server database? Both products are owned by SAP (formery Sybase) but are totally different DBMSes...

If you really are using ADS, I would recommend to ask questions in a different place, namely the SAP ADS Community.

(05 Jan '21, 05:41) Volker Barth

Hi Vokler:

When I submit a question, specifying a tag is must, but I cannot create a new tag, so I randomly choose an existing tag (which I know it does not apply to my case). Thanks.

(05 Jan '21, 18:22) VMeng
Replies hidden

In most cases, this would suggest that there is a corruption with the database. The next course of action would generally be to go to your recovery plan. Do you have a backup of this database?

I would suggest that getting more details about the problem with the database if you are looking for help in the absence of a recovery plan. Can you start a copy of the database at the command line i,e,

dbeng17 -o console.log <database>

and/or run a database validation i.e. (replacing *** with correct values),

dbvalid -c "eng=dbvalid;dbf=<database>;uid=***;pwd=***"
(05 Jan '21, 21:57) Chris Keating

I randomly choose an existing tag (which I know it does not apply to my case).

Please choose tags that at least do not lead to false directions. You can certainly choose an existing tag for the SQL Anywhere version you are using, such as sa-17, asa-9 or the like.

(06 Jan '21, 03:09) Volker Barth

How do you know the file is actually a "SQL Anywhere database" file and not some other kind of file?

Does it even have the *.db extension?

What command did you use, when you got the error message?

(07 Jan '21, 15:34) Breck Carter
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: 05 Jan '21, 04:06

question was seen: 3,054 times

last updated: 07 Jan '21, 15:34