Connect to SqlAnyhwere using the user is DBA with password 'sql', default database demodb.
dbsrv12 -x tcpip -n server1
The default database user is 'DBA' with password 'sql'. The demodb may be installed.
From Sybase Central you can create a new database. You will have to enter the file location. Then you will have to create a service for it. You can do this by selecting the SqlAnywhere:
Then the service tag:
The service can be started also from the Command Prompt using the command:
dbsrv16.exeJust execute this and a dialog will ask for the database location and server name. Then you can connect to it from the Sybase Central using the server name. If you get permission errors try to run the Command Prompt as Administrator. There is no need to create a server for the created database, just a Service is enough.
Some useful queries:
// list dbspaces ( are tablespaces with associated files ) select * from sysdbspace; CREATE USER bubu IDENTIFIED BY bubu; GRANT CONNECT TO bubu; GRANT RESOURCE TO bubu; GRANT CREATE on system to bubu; COMMENT ON USER bubu IS 'Test user to test some system features without DBA privileges.';