Sybase db-creation error

I have installed Sybase Central inside my parallels.
When I want to create a new db in Sybase, I’ll get an error.

When I do it with the dbinit commandline tool, I’ll get this

D:\Servoy\Servoy3_install\sybase_db>dbinit.exe -t directmanager.log -z UTF8 directmanager.db
Adaptive Server Anywhere Initialization Utility Version 9.0.2.2451
Creating system tables
Collation sequence:  UTF8
Creating system views
Error in file mksadb60.sql at line 2250 with sqlcode -131
SQL error (-131) -- Syntax error near 'uniqueidentifier' on line 1
Database "directmanager.db" not created

D:\Servoy\Servoy3_install\sybase_db>

this is fresh install of Sybase iAnwyhere.
What am I doing wrong here?

Apparently, there seem to be some buggy system scripts in the Sybase install.

Take the entire servoy/sybasedb/script directory, and copy that over the scripts directory in your sybase installation (create a backup first would be recommended).

The above fixed it for me at least.

Paul

But I tried the dbinit in the Servoy folder also, but here the same error.
Or does the dbinit ‘look’ at the sql files of the Sybase install??

Guess it does… I just recognize the error.

BTW: the scripts dir that needs replacing is: …\Sybase\SQL Anywhere 9\scripts

Paul

Still no luck!

Microsoft Windows XP [versie 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

D:\Servoy\Servoy3_install\sybase_db>dbinit -m directmanager.log directmanager.db

Adaptive Server Anywhere Initialization Utility Version 9.0.2.2451
SQL error (-82) -- Unable to start specified database: unable to start database
"directmanager.db"
Database "directmanager.db" not created

D:\Servoy\Servoy3_install\sybase_db>

I don’t get it. I had never had this problems before. :-(

Mmm, seems that the database creation was successfull now, only starting it is a problem, right?

no the db is not created!

the strange is, that I completly de-installed Sybase Ianywhere.
And I start the dbinit from inside my sybase_db folder.

Microsoft Windows XP [versie 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

D:\Servoy\servoy3_convert\sybase_db>dbinit.exe -m test.log test.db
Adaptive Server Anywhere Initialization Utility Version 9.0.2.2451
SQL error (-82) -- Unable to start specified database: unable to start database
"test.db"
Database "test.db" not created

D:\Servoy\servoy3_convert\sybase_db>

I now see that you tried to create a new DB from within the Sybase directory in the Servoy installation.

The first error you got, I’ve seen before, but then in Sybase Central or in the Sybase installation itself. The fix to that was moving the correct scripts from the Servoy install to the Sybase install.

But you have the issue the other way around: it doesn’t work for you int he Servoy install…

Does it work if you create the DB from Sybase Central?

The Servoy install where you are trying to create the new DB: Have you been able to create new DB’s there before? Or is it a fresh Servoy installation? If the latter: Maybe an idea to compare the scripts folder in the new Servoy install against an old Servoy install where you are able to create new DB’s.

Paul

I’m trying to create a database with dbinit that comes with the Servoy 3.5.6 install (Sybase 10).

I get the SQL error (-82) same as Harjo…

I don’t want to install Sybase Central 10 because I have Sybase Central 9 install on this trial conversion…

Has anyone (Harjo?) been able to create a database this way? Is there a way to get this to work or will I have to put Sybase Central 10 on another dev machine and create the database using it?

Thanks in advance for your help!

No, I have been able only to do this, when Sybase Central is also installed!
(restart your OS after installation of Sybase Central!)

I’m running:
Windows XP Pro
Dell Vostro 1710 (new machine)
Java 10.0-b19
Servoy 3.5.6 (first time install)

I can’t get Servoy to create a db using the command line process in the documentation or using the ianywhere-utility solution and I always get the same error you are getting -82. The database is not being created in anywhere inside the install directory.

I haven’t been working on the window side very long, cut my teeth on the Mac side

Any help would be greatly appreciated

Hi Armando,

It looks like you need to install Sybase Central to be able to do that, even from the command-line. You can download it for free (as a developer) from the Sybase site.
Hopefully someone from Sybase and/or Servoy can shed some light on this issue why the bundled tools are not able to create databases.

Hope this helps.

I have created a support ticket for this: 141612

I have other question for you. I have gone to the Sybase site but I can’t fine Sybase central 10 download, do you have a url where I could find it?

Thanks for everything!
Armando

Thanks Harjo for everything you do for the community

Hi Armando,

Armando.Alonzo:
I have gone to the Sybase site but I can’t fine Sybase central 10 download, do you have a url where I could find it?

You can download version 9 and 10 at the following URL:

http://www.sybase.com/detail?id=1055872

It seems that its needed to set the directory sybase_db/scripts in your path before running any of the sybase tools.

In Servoy 4.0 creation of a database file is possible in the developer