When I open Sybase Central and connect by right-clicking Adaptive Server Anywhere 9 within the left panel, the servoy_repository appears at two levels, which I assume to represent the repository and a database within the repository. The double use of the name “servoy_repository” seems confusing to me.
I had thought new databases were to be created by right-clicking the first servoy_repository and selecting “Create Database”, which would default to placing the newly created database at the same level but separate from the servoy_repository database. This would be at the same level as the sample databases provided by Servoy.
However, the instructions on page 468 of the Servoy Developer Volume I manual say to create a new database by going to the Tools pulldown menu at Tools > Adaptive ServerAnywhere 9 > Create database, which defaults to creating the database on the same level as the first servoy_repository item, creating what appears to be a new repository plus a database with the same name (using that double naming convention again).
What are the pros and cons of each of these two locations for newly created databases? Should they be created at the same level as the Servoy sample databases, or at the higher level?
The first “servoy_repository” is the name of the server instance of Sybase and not the database. Basically, unless you start the server with the -n option and supply a name, it defaults to the name of the database it is opening, which in thhis case is servoy_repository.
In Servoy developer in the preferences/DB Servers should be labeled DB connections as that’s what they really are. This is confusing and to make it worse, in a given connection, um, “DB Servers”, the connection name is labeled, “DB Server”. Here’s what would help:
allow user to provide a name for the actual sybase server in the preferences tab (this would just send the -n at startup. Alternateley, it should send a generic name like “sybase-servoy” or just “sybase-server”.
rename DB Servers in preferences to “DB Connections”
rename the connection label from “DB Server” to “Connection Name”
bob cart:
The first “servoy_repository” is the name of the server instance of Sybase and not the database. Basically, unless you start the server with the -n option and supply a name, it defaults to the name of the database it is opening, which in thhis case is servoy_repository.
In Servoy developer in the preferences/DB Servers should be labeled DB connections as that’s what they really are. This is confusing and to make it worse, in a given connection, um, “DB Servers”, the connection name is labeled, “DB Server”. Here’s what would help:
allow user to provide a name for the actual sybase server in the preferences tab (this would just send the -n at startup. Alternateley, it should send a generic name like “sybase-servoy” or just “sybase-server”.
rename DB Servers in preferences to “DB Connections”
rename the connection label from “DB Server” to “Connection Name”
Bob,
It is true that the tab in Application Preferences is named “DB Servers”.
However, the Servoy documentation DOES describe these servers as
database server connections. The definition of these “connections” is
introduced beginning on page 465, the Database Connections chapter, in
the printed version of the Servoy Developer Edition User’s Guide.
Marc , it would be great if both the manuals and user interface used the term “connection” perhaps in addition to “server”, if that is required language for other databases. This might help reduce confusion for new users and help people understand the relationship between SQL servers and Servoy better.