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
