Hi!

I want to validate a Database without modifying the Database.
The documentation gives two Opportunities... validate a copy of the Database
or validate the database in read-only mode.

If I tried it, I get an error (SQL-error -304) with text "acceess denied"
and "disk full" .

I use SA 11.0.1.2308

I combined the dbvalid with the start of the databse-engine.
Command:
"%SABIN%\dbvalid.exe" -c "START=%SABIN%\dbeng11.exe -r -ca0 -c256M -n
db_valid %PATHDB%\db_test.db;uid=DBA;pwd=sql;ENG=db_valid"

What did I wrong or is it a bug?

regards
Ingmar

Hi,

I changed my command:
"%SABIN%\dbvalid.exe" -c
"START=%SABIN%\dbeng11.exe -r -ca0 -c256M;DBN=db_valid;DBF=%MAFIS_VDB%\db_test.db;uid= DBA;pwd=sql"

Now dbvalid works. But i do'nt know why.
According to the documentation i would say, that my first way should work
also. Right?

Regards


<Ingmar> schrieb im Newsbeitrag news:4acf1c56 (AT) forums-1-dub (DOT) ..

No. You should not specify the server or database names or database
files in the START parameter - that's what the ENG, DBN, and DBF
parameters are for. The client needs to know the ENG and DBN values in
order to connect, and it cannot parse the start line to find out what
they are.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Ingmar wrote: