Help!!! - cannot create database???

I just downloaded the 4.0.1 community edition release and installed on clean machine with xp/sp3 , correct JDK .
Launched the servoy developer and saw several databases (log_db, UDM, User_Data …etc) , right clicked on one of these and selected the create database - filled out the name and then it gives error message - unable to start database - error 82.

The database is running - i see a lightening icon in the tray and also if I select any of the existing databases I can see the tables and fields in them.

What am I missing here or not doing correctly?

Any hints will be greatly appreciated.

Jenna Ginto

jennaG:
I just downloaded the 4.0.1 community edition release and installed on clean machine with xp/sp3 , correct JDK .
Launched the servoy developer and saw several databases (log_db, UDM, User_Data …etc) , right clicked on one of these and selected the create database - filled out the name and then it gives error message - unable to start database - error 82.

The database is running - i see a lightening icon in the tray and also if I select any of the existing databases I can see the tables and fields in them.

What am I missing here or not doing correctly?

Any hints will be greatly appreciated.

Jenna Ginto

Hi Jenna - I assume you’re using Sybase (mentioned the lightening bolt LOL).

You neeed to create your database in Sybase itself (probably using the Sybase Central tool), and then use Servoy Developer to create a ‘database server connection’. This is where you specify the connection to the database you have created in Sybase.

If you right click on one of the other database server connections in developer you can create a ‘table’ but not a database!

hi kahuna,

creating a database using sybase central is no problem, the whole idea behind servoy 4 was that it comes with the SQL anywhere bundled with servoy and you should be able to follow the process I described to crate a new sybase database.

I actually even saw a flash demo on this site where they show it being done, why then it does not work?

This seems like a BUG in the release.

Anyone form servoy care to comment please - ?

jennaG:
hi kahuna,

creating a database using sybase central is no problem, the whole idea behind servoy 4 was that it comes with the SQL anywhere bundled with servoy and you should be able to follow the process I described to crate a new sybase database.

I actually even saw a flash demo on this site where they show it being done, why then it does not work?

This seems like a BUG in the release.

Anyone form servoy care to comment please - ?

I could be wrong Jenna - but Servoy have specifically stated that you cannot use developer to create a database, and have also specified Sybase Central as the chosen tool to do that. I cant find any functionality in developer to create a database??

Can you indicate where the ‘create database’ command or menu selection is?

I’d be really interested to see the Flash video you mention too - can you provide a link?

jennaG:
This seems like a BUG in the release.

Correct, add the scripts directory to your path environment variable (needed on windows only)
path=%path%;C:\Program Files\Servoy\application_server\sybase_db\scripts

Will be corrected in next Servoy releases

Jan - Thank you for the information - I will try it and seems logical now why it would not work.

Kahuna - you can see the falsh videos on this link:
http://www.servoy.com/generic.jsp?mt=396&taxonomy_id=790&pageid=hltutorials

The one of real interest where you see the problem and also the feature of creating a sysbase database within the developer is in the Iphone applicaiton flash video.

jennaG:
Jan - Thank you for the information - I will try it and seems logical now why it would not work.

Kahuna - you can see the falsh videos on this link:
http://www.servoy.com/generic.jsp?mt=396&taxonomy_id=790&pageid=hltutorials

The one of real interest where you see the problem and also the feature of creating a sysbase database within the developer is in the Iphone applicaiton flash video.

Thanks Jenna - I had’nt seen the iPhone demo. I’ll take a look.

Cheers

Sorry but where can I find the PATH ENVIRONMENT VARIABLE?

(path=%path%;C:\Program Files\Servoy\application_server\sybase_db\scripts)

Thanks,
Ron

  • Right-click My Computer, and then click Properties.
  • Click the Advanced tab.
  • Click Environment variables.
  • There you’ll see a list of System variables, path is one of them.

But if you just do “path=%path%;C:\Program Files\Servoy\application_server\sybase_db\scripts” in a console, the scripts folder is added to your path.