have u
tried to go in the server, dbmcli and do:
db_restart
db_online
db_state
db_enum
bye
send here the commands results
maxsoft
irc-chat:
server address: LasVegas.NV.US.Undernet.org
server port: 6667
channel: #sapdb
irc-chat:
server address: LasVegas.NV.US.Undernet.org
server port: 6667
channel: #sapdb
-----Messaggio originale-----
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Per conto di Adriano Ferlin
Inviato: gioved� 13 febbraio 2003 16.45
A: '[EMAIL PROTECTED]'
Oggetto: RE: SQL Studio navigation tree is empty!!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.
