>From W2k DBMGUI, you can use Register or install instance, then in the second name after database name put your remote linux server ....
While using register, you can discover installed database on remote linux. Just put ip address, then click the button with sign ! the list of your database on remote server will displayed ----- Original Message ----- From: "Andreas K�hl" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 28, 2003 3:31 PM Subject: Re: Connecting with GUI Tools from W2k to SAPDB on Linux fails > Hi Wolfgang, > thanks for your answer. How can i connect from W2k with the DBM GUI to my > remote LINUX database? > > I've did some more investigation and there are problems with the catalog. > I've tried it with dbmcli the following way, as it is described to make the > demo database: > <dbmcli -d total1 -u dbm,dbm load_systab -u dba,dba -ud domain> > The output is: > ERR > -24964,ERR_EXECUTE: error in program execution > 768,/opt/sapdb/depend74/bin/x_python /opt/sapdb/depend74/env/lsystab.py -d > TOTAL1 -u dba,* -dompwd domain en ENG > ---------Traceback--------------- > File "/opt/sapdb/depend74/env/installib.py", line 335, in > connectAndInstall > installRoutine (session, options) > File "/opt/sapdb/depend74/env/lsystab.py", line 65, in install > stopIfSqlNotOK (session, """CREATE PACKAGE SYS_DDL_PACKAGE AS > 'liveCache.dbpInstall.V72' INPROC""") > ---------Command----------------- > CREATE PACKAGE SYS_DDL_PACKAGE AS 'liveCache.dbpInstall.V72' INPROC > ---------Error------------------- > loader.LoaderError: [-25010] SQL [-7500] Message not available:00000002 > (error position: 1) > > Maybe there are wrong versions mixed. Do you have any ideas? > > Regards, > Andreas K�hl > > > "Auer, Wolfgang" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > news:[EMAIL PROTECTED] > > Hi Andreas, > > > > For the SQL Studio problem it seems that the catalog of the database is > not complete. > > Please reload the system tables with the DBM GUI. > > > > Regards > > Wolfgang > > > > -----Original Message----- > > From: Andreas K�hl [mailto:[EMAIL PROTECTED] > > Sent: Mittwoch, 27. August 2003 15:44 > > To: [EMAIL PROTECTED] > > Subject: Connecting with GUI Tools from W2k to SAPDB on Linux fails > > > > > > Hi, > > two problems with Windows GUI Tools: > > > > 1. Try to connecting with the Database Manager to a remote database on > Linux > > fails. Have i missed some prerequisites? If you try to register a database > > on a specified IP address, '-4 communication error' will displayed. > > Connecting to a local database works fine. > > > > 2. Connecting with SQL Studio to a remote database on Linux over ODBC is > > possible but after a connection is established, a window with the > following > > text appears ( SQL Studio does not support the catalog view when > connected > > to databases prior to 7.3.0) and you can not navigate in the tree view, > > cause nothing is displayed. Connections to a local database again, is > > working fine. I've downloaded the latest SQL-Studio and ODBC Driver from > > sapdb.org. The remote database version is: 7.4.3.27. > > The trace window shows the following: > > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > > > > Base table not found;-4004 POS(28) Message not available:DBPROCEDURES. > > > > SELECT DISTINCT owner FROM domain.dbprocedures WHERE DBPROCNAME LIKE '%' > > > > ---- Error ------------------------------- > > > > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > > > > Base table not found;-4004 POS(28) Message not available:TRIGGERS. > > > > SELECT DISTINCT owner FROM domain.triggers WHERE TRIGGERNAME LIKE '%' > > > > Does anyone has some suggestions for that problems? Thanx in advance! > > > > Andreas K�hl > > > > > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
