Error using Sybase command line

Classic Servoy
1

Today I tried to create a db on my MacOS X laptop, but I got this error
macbook-ric:/Applications/Servoy3/sybase_db ric$ ./dbinit -t mydb.log -z UTF8 mydb.db
Adaptive Server Anywhere Initialization Utility Version 9.0.2.3045
The DBTOOLS DLL is an old version

I installed Sybase 10, some time ago: should I remove it to be able to use this command again?

I know I could create the db using Sybase Central’s tools, but I prefere to use Sybase 9, for now.

Any idea?

2

Riccardino,

It looks like the wrong version of dbtools is being loaded. You should be able to run both SA9 and SA10 on the same machine, provided you install them on different folders and source the appropriate config file (asa_config.sh for v9 and sa_config.sh for v10).

Note that to install SA on the non-default folder (i.e.: not in /Applications), you must run the text version of the setup (e.g.: ./setup -nogui). This will allow you to enter the location where you want to install SA.

Regards,

Jose

Riccardino:
Today I tried to create a db on my MacOS X laptop, but I got this error
macbook-ric:/Applications/Servoy3/sybase_db ric$ ./dbinit -t mydb.log -z UTF8 mydb.db
Adaptive Server Anywhere Initialization Utility Version 9.0.2.3045
The DBTOOLS DLL is an old version

I installed Sybase 10, some time ago: should I remove it to be able to use this command again?

I know I could create the db using Sybase Central’s tools, but I prefere to use Sybase 9, for now.

Any idea?

3

jramos:
Riccardino,

It looks like the wrong version of dbtools is being loaded. You should be able to run both SA9 and SA10 on the same machine, provided you install them on different folders and source the appropriate config file (asa_config.sh for v9 and sa_config.sh for v10).

All I did is to install Sybase 10 into /Applications.
Now I have 3 folders named (by me) “SQLAnywhere9”, “SQLAnywhere901” and “SQLAnywhere10”.

Could this renaming be the reason of the problem?

4

The dbtools library should be located in the folder /System/lib32 of your SQL Anywhere installation. Since you have three different installs, there should be three different versions of the library (its name is libdbtool#_r.dylib, where # is either 9 or 10).

Do you know which one you are calling? The library path that SA will look for is defined by the environment variable DYLD_LIBRARY_PATH. The path should include the library folder above - so have a look to see if more than one folder shows up and make sure it is the correct one.

The DYLD_LIBRARY_PATH variable is defined when you source the file /System/bin32/sa_config.sh.

Thanks,
Jose

5

jramos:
The DYLD_LIBRARY_PATH variable is defined when you source the file /System/bin32/sa_config.sh.

Hi Jose

I’ll check the settings.

Thanks again.