Hi Markus,

     Thanks for your attention. I did what you said, but the problem persists. I have used this script to create new users:

CREATE USER test PASSWORD test DBA NOT EXCLUSIVE

and

CREATE USER test1 PASSWORD test1 DBA EXCLUSIVE

    I tried to connect with both users, and in WAN Mode too, but the tree navigator doesn't lists the objects of the database. I tried to reinstall the SQL Studio, ODBC driver and DBM GUI too.

    I really don't know what to do. I'm thinking to reinstall sapdb. Do you have some idea??

    Thanks,

 

Adriano.

 "Stausberg, Markus" <[EMAIL PROTECTED]> wrote:

Hi Adriano,

you wrote :
>I'm connected to a linux server with sapdb 7.4.3. I'm using Win2000 and SQL Studio to generate >tables remotely, but when I start SQL Studio as SYSDBA, no one table, indexes or sequences
>appears in the navigation tree. The database is running. What is going wrong?

There are three possible reasons for this behavior :
1. The system tables have not been loaded properly during instance creation
You could redo this using e.g. DBMGui.
2. You are in SQLStudio WAN mode, which is more bandwidth friendly for connecting
over a slow (e.g. modem) connection.
3. The user sysdba was not created as 'not exclusive' , thus, can only use a single
db connection (the catalog manager needs a second one besides the one which
is used for submitting user queries).

check these conditions, if problems persist, feel free to post agai! ! n.

regards

Markus Stausberg
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general



Busca Yahoo!
O servi�o de busca mais completo da Internet. O que voc� pensar o Yahoo! encontra.

Reply via email to