Additional NOTE to the above: after creating the database you must add it to the file sybase.config located in the sybase_db directory.
Sybase Central can be downloaded for free and you can use it for many administrative functions. More documentation about the external tools will appear in the next version of our documentation.
You can also create databases on the command line/prompt:
1. open a terminal (linux, unix, os x) or a command prompt
2. change directory to your Servoy installation directory
3. change directory to the sybase_db directory inside you Servoy directory
4. a. On mac os x set your DYLD_LIBRARY path to this directory
Using bash:
- Code: Select all
export DYLD_LIBRARY_PATH=/path/to/sybase_db
for example:
- Code: Select all
export DYLD_LIBRARY_PATH=/Applications/Servoy/sybase_db
Using tcsh:
- Code: Select all
setenv DYLD_LIBRARY_PATH /path/to/sybase_db
example:
- Code: Select all
setenv DYLD_LIBRARY_PATH /Applications/Servoy/sybase_db
b. On Linux/Unix:
Using bash:
- Code: Select all
export LD_LIBRARY_PATH=/path/to/sybase_db
for example:
- Code: Select all
export LD_LIBRARY_PATH=/usr/local/servoy/sybase_db
Using tcsh:
- Code: Select all
setenv LD_LIBRARY_PATH /path/to/sybase_db
example:
- Code: Select all
setenv LD_LIBRARY_PATH /usr/local/servoy/sybase_db
c. On Windows:
- Code: Select all
set ASANY9=\path to sybase_db
for example:
- Code: Select all
set ASANY9=c:\Program Files\Servoy\sybase_db
5. create the database using the following command:
a. On OS X, Linux and Unix:
- Code: Select all
./dbinit -t <name>.log -z UTF8 <name>.db
b. On windows:
- Code: Select all
dbinit.exe -t <name>.log -z UTF8 <name>.db
add the databse to the sybase.config file in the sybase_db directory. If you created the database in the database directory create a line like this:
- Code: Select all
database/mydb.db
if you created it somewhere else put the full path to the database in the config file.
Finally make sure you have stopped the database server for it to automatically start the database when Servoy launches. On Windows: right click the SQL tray icon and choose Exit. On Mac, Linux, Unix: kill the dbsrv* processes. You can also stop the database using dbstop in the sybase_db directory:
- Code: Select all
./dbstop -c "eng=servoy_repository;uid=DBA;pwd=SQL"