Hi, I've just installed SQL Anywhere Studio 7.0. I'd like to create a
database and populate it with some tables.

But before creating a database, I need to connect to a server.

There's a demo server that comes with the installation ("asademo") but
I'd like to create my own server and then connect to it.

Neither I nor my colleague have figured this out yet.

Seconday question: What's the relationship between SQL Anywhere and
Sybase Central. It seems like the latter is a management GUI for
taking care of things (such as creating servers and databases.)

Any help greatly appreciated. Pardon our ignorance.

P.S. Our ultimate goal is to migrate from Paradox to SQL Anywhere.

The server and the database are pretty much inseparable - you can't have one without the other. A server (or engine)
isn't running unless it has at least one database mounted, and the process of mounting a database automatically starts
an engine to do it. An engine can manage multiple databases, but you can also have multiple engines running, each with
their own databases.

For example, if you double-click on the asademo.db file (then associate it with the DBENG7.exe application), you'll
start an engine AND mount that database file at the same time. Both the server (engine) name and the database name
within that engine will be ASADEMO.

Sybase Central is indeed the management GUI for SQLAnywhere databases. Here's one thing you can do.
- Start Sybase Central.
- In the Utilities folder, select Create Database. That walks you thru the wizard for creating a new .db file.
- At the end, it will ask you if you want to connect to the new database. Say yes. The default admin UID/PWD is
dba/sql.
Now you can create any type of schema object you want.

You can also create Windows Services that start databases/engines. This is all well documented in the SQLAnywhere help
files.

Can I ask why you went with SQLAnywhere 7? That version has been end-of-lifed, as ASA9.0.1 is now the latest release...

--
Paul Horan[TeamSybase]

PS. Go to news://forums.sybase.com/sybase.publ...ywhere.general for more thorough support and info on this
product.


"Google Jenny" <michiamo (AT) yahoo (DOT) com> wrote