C:\Programme\Servoy\sybase_db>dbinit.exe -t pte.log -z UTF8 pte.db
Adaptive Server Anywhere Initialization Utility Version 9.0.0.1108
Creating system tables
Collation sequence: UTF8
Creating system views
Setting permissions on system tables and views
Setting option values
Error in file saopts.sql at line 282 with sqlcode -201
SQL error (-201) – Invalid setting for option ‘Prefetch’
Database “pte.db” not created
I’m unable to reproduce that problem. On which OS version and Servoy version do you experience this?
Also: in your post it appears that you don’t have a space behind the SET keyword.
jaleman:
I’m unable to reproduce that problem. On which OS version and Servoy version do you experience this?
Also: in your post it appears that you don’t have a space behind the SET keyword.
I’m working with WinXP (German) and Servoy 2.1 rc2. The space behind the SET keyword I forgot in my post only.
Today I have updated the database (ASA) from 9.0.0 up to 9.0.1. Now it works fine.
I am getting the same error as above with the new build from Sybase
Creating system tables
Collation sequence: 1252LATIN1
Creating system views
Setting permissions on system tables and views
Setting option values
Error in file saopts.sql at line 282 with sqlcode -201
[Sybase][ODBC Driver][Adaptive Server Anywhere]Invalid setting for option ‘Prefetch’
The database file ‘C:\Program Files\Servoy\database\Test1.db’ could not be created.
I am doing this in Sybase Central, not from the command line. Am I doing something wrong? Is this a bug with ASA?
WinXP SP2
Servoy 2.1
Adaptive Server Anywhere 9, version 9.0.1.1922