Ошибка возникает при создании любой таблицы?
Есть права на создание таблиц в той базе, в которой находишься?

Возможно это та самая ошибка, сам с ней никогда не сталкивался.

Error message text
Unable to create table '%.*s' because it has no remote storage location defined. Creation of local user tables is allowed only in the master and tempdb databases.

Explanation
Component Integration Services (CIS) is a feature that extends Adaptive Server capabilities and allows you to access and manipulate tables in remote servers as if they were local tables. When you install Adaptive Server, files needed to interact with CIS are placed in the installation directory.

Error 11202 is raised when you attempt to create a table, but Adaptive Server is unable to locate or otherwise access one of these files. The problem can occur even if you are creating a local table and do not utilize CIS.

Action
Use the following checklist to ensure that the necessary file is accessible:

Check that the SYBASE environment variable is properly set. If you recently upgraded, make sure that this variable was updated. Restart the server after checking this variable.

Make sure that you start the server as user sybase.

Check that the files dsopt1 (necessary for local tables) and dsopt2 (necessary for remote tables) exist in your installation directory. For example, in Unix sites the file $SYBASE/install/dsopt1 must exist with read permissions before you can create local tables. Restore any missing files and restart Adaptive Server.


The ASE directory structure has changed with 12.0. Check your Installation and Configuration guide for details.