how to create new db into servoy repository connection

[lcr159]

I had to install again Central from the last release of SA902, and now it makes error creating new db into the servoy repository connection, as

Creating system tables
Collation sequence: UTF8
Creating system views
Setting permissions on system tables and views
Setting option values
Initializing UltraLite deployment option
Error in file oleschem.sql at line 177 with sqlcode -131
[Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error near 'uniqueidentifier' on line 22
The database file 'C:\Programmi\Servoy\database\newdb.db' could not be created.

or

[Sybase][ODBC Driver][Adaptive Server Anywhere]Cannot access file 'mksadb60.sql' -- No such file or directory
The database file 'C:\Programmi\Servoy\database\newdb.db' could not be created.


I read that there are problems, but what is the final solution to have the possibility to create db, also without Central?

Please help, I need to make some new db very soon!

[Jan Aleman]

It sounds like a bug in sybase latest installer. Meanwhile you can also create databases command line:
- cd to the sybase_db directory inside your servoy directory then type:

Code: Select all

dbinit -t ..\database\mydb3.log -z UTF8 ..\database\mydb3.db


[r.schneider]

I got the same error when I try to create a database with DOS commads.

jalemans hint does not work.

what can i do to create a database?

[Jan Aleman]

try to unset possible paths to asa:

SET ASANY=
SET PATH=

in your command window before db creation.

[r.schneider]

I was able to create a new database using the syntax on a differnt machine:

set ASANY9=c:\programme\servoy\sybase_db

dbinit.exe - t c:\programme\servoy\database\mydatabase.log -z UTF8 c:\programme\servoy\database\mydatabase.db

On the machine, that does not work, I have installed SQL Anywhere 9

Maybe thats the problem....

[Jan Aleman]

Interesting. I'd think that if you unset any variables to sybase directories that shouldn't make a difference.