Sybase Central error trying to create a database

Classic Servoy
1

I get the following error when trying to create a database:

Creating system tables
Collation sequence: 1252LATIN1
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:\Documents and Settings\Administrator\Desktop\tempdb.db’ could not be created.

This is with a new install and I’ve tried it with two different machines: one running XP-2 and the other Windows 2000.

I don’t have any old installs around to compare except my Mac (which works fine). Is anyone else having this problem with new installs on windows machines? The version I downloaded is Sybase Central 4.3.0.2387.

2

bug report and follow up info here:

http://forum.servoy.com/viewtopic.php?p=21894

3

David,
Where can I download Sybase Central?
I use SQL Anywhere 9 for making databases. But this is a trial version.

4

Sybase Central is part of SQL Anywhere Studio.
You can download it from here:

http://www.ianywhere.com/products/sql_anywhere.html

It’s free for developers.

5

This is strange. Do you have multiple installations of SQL Anywhere with different versions on your machine?

6

First time installation of Servoy (and Sybase) on both machines. On further testing, I get this error only when trying to create a new database on the servoy_repository server. Everything works fine when using the asademo server.

7

If I were to guess the problem. The version of the scripts in the SQL Anywhere scripts directory do not match the version of your software. What version of SQL Anywhere are you using?