analyse database

[Former Member]

Hi,

I've got a database file (*.db) from a customer who asks me to analyse its content. All what he knows is that it's a SQL Anywhere database, but no version number.

I've already downloaded SQL Anywhere Developer version 12 and 10. But both products reports a connection error, that this database was created with another version.

So how can I detect the database version to download the right developer suite ?

[Former Member]

Bingo, DBA and SQL works well. I can log on and can view all tables and data with Sybase Central.

Anyway, is there any limitation for this user in viewing all data ? When I open the Dbspaces folder and select here the System node, then all tables are listed on the righthand side with a column "Aprx. # Rows", which probably means "aproximated number of rows".

Here a special table is listed with about 130.000 rows. But when I switch to the Tables folder and select "View Data in Interactive Sql" in the context menu for this table, scrolling stops at 500 rows.

[VolkerBarth]

That's the default option independent of the particular users:

DBISQL (also when used from within Sybase Central) just displays the first 500 rows of a result set.

Look here how to change this (somewhat incomfortable) default by means of the "Options/SQL Anywhere options" menu...