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).
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.
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.
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?
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
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.