create new database with command line + mac os x 10.3.4

Classic Servoy
1

Hi folks,

I’ve a problem. I’ve to create a new Sybase database for testing, I haven’t downloaded Sybase Central, then I’m trying with the command line.

My installation: /Applications/Servoy
I’ve exported the variable DYLD_LIBRARY:
export DYLD_LIBRARY_PATH=/Applications/Servoy/sybase_db

then in sybase_db I’ve tryed with:
./dbinit -t newdb.log -z UTF8 newdb.db
(note: in the help documentation there’s a type error: there isn’t the ‘.’ before ‘/’)

but the output was:
Adaptive Server Anywhere Initialization Utility Version 9.0.0.1121
SQL error (-80) – Unable to start database server
Database “dbweb.db” not created

what’s error -80? What could I do? I’ve checked the permissions, but nothing, all is ok, I think.

thanks for any suggestion.
Regards
Andrea

2

Do you already have a server running on the network with the same name perhaps?

I would suggest shutting down any other servers you have running and try again. initting a db requires dbeng9.exe also, not just dbsrv9.exe - check that.

3

It looks like the docs are not entirely complete on the command line creation on Mac. You als need to set a PATH variable to the sybase_db directory.

export PATH=$PATH:/Applications/Servoy/sybase_db

We will adjust the documentation accordingly

4

jaleman:
We will adjust the documentation accordingly

thanks Jan,

now all’s ok, here my steps:

cd /Applications/Servoy/sybase_db
export DYLD_LIBRARY_PATH=/Applications/Servoy/sybase_db
export PATH=$PATH:/Applications/Servoy/sybase_db
./dbinit -t testdb.log -z UTF8 testdb.db

and here the output:

Adaptive Server Anywhere Initialization Utility Version 9.0.0.1121
Creating system tables
Collation sequence: UTF8
Creating system views
Setting permissions on system tables and views
Setting option values
Initializing UltraLite deployment option
Database “test.db” created successfully

thanks for all
Regards
Andrea

5

Excuse me, Jan,

but I think that

export DYLD_LIBRARY_PATH=/Applications/Servoy/sybase_db
export PATH=$PATH:/Applications/Servoy/sybase_db

cd /Applications/Servoy/database
/Applications/Servoy/sybase_db/dbinit -t testdb.log -z UTF8 testdb.db

is better, because in this case I create a db in ‘database’ directory, and not in ‘sybase_db’, as instructions, isn’t it?

thanks for your suggestions.
Regards
Andrea

6

yes, it’s best to create databases in that directory. Excellent suggestions, thanks very much.

7

..but the output was:
Adaptive Server Anywhere Initialization Utility Version 9.0.0.1121
SQL error (-80) – Unable to start database server
Database “dbweb.db” not created

I had “exactly” the same problem some days ago and had to use sybase central.
I found this solution only today browsing around the forum:

We will adjust the documentation accordingly

is there a way to have some type of notification about changes in documentation for solved bugs?
I’m going from filemaker to servoy (having passed from 4D to filemaker…), and it’s not “really” so simple :(
.. but the benefits are too big!
I find Servoy really a great piece of work!

M. Michelutti
Vicenza, Italy

8

Every version of the documentation has many hundreds of changes and additions so a change log would be nearly as large as the documentation itself. Always when in doubt: search the forum and/or post.

If you’ve been using 4D and Filemaker in the past you’ll find that Servoy is much and much easier to learn than any of them.

9

Michael:
is there a way to have some type of notification about changes in documentation for solved bugs?

Jan Aleman:
Every version of the documentation has many hundreds of changes and additions so a change log would be nearly as large as the documentation itself. Always when in doubt: search the forum and/or post.

Michael,

While it is true that each new version of the documentation contains too
many changes to list every change with each update, the documentation
team does read every post to the Servoy Forum.

It is your posts to the Forum that in large part help to make changes or
additions to the documentation in order for all that information to be
presented more clearly and become an even more functional and useful
tool for Servoy developers.

Marc Norman
Servoy