DBMGUI Startup problem: 35602

2004-01-15 Thread Matthias Gärtner
Hello, after upgrading to Database Manager 7.5.00.03 from 7.4 the DB Manager fails to start up with the following dialog box (Windows XP): DBMGui3 Run Time error '35602' Key is not unique in Collection After clicking OK, the program terminates. I tried re-installing the 7.4 version again (worked

RE: 32 bit on x86-64 ?

2004-01-15 Thread Dittmar, Daniel
> btw, I just tried to install 32-bit MaxDB 7.5 to Windows/x86-64. > And it installs ... > Only problem is that I can't create database then: > > C:\Program Files (x86)\sdb\7500\misc>1.cmd > ERR > -24875,ERR_NEEDADMI: The operating system user is not a member of the > database administrators group

RE: Unsucessfull attempt to build MaxDB 7.5.0.05

2004-01-15 Thread Dittmar, Daniel
> >This looks like a porting problem. Could you try to find out > which system header > >defines _SC_CLK_TCK. That include is probably missing from > sys/src/libptc/sql__clock.c > > > I have found _SC_CLK_TCK at the file > MaxDB_ORG/sys/src/SAPDB/RunTime/System/RTESys_SystemInfo.c > as an argumen

RE: database crashes

2004-01-15 Thread Hahn, Uwe
Hi Stephane, please send me the protocol files knldiag, knldiag.err, dbm.utl, dbm.prt and dbm.knl from your database. Kind regards, Uwe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 11:08 AM To: [EMAIL PROTECTED] Subject: database

RE: Trigger, decode

2004-01-15 Thread Anhaus, Thomas
Dusan Kolesar wrote : >Hello >I have two tables: >CREATE TABLE "ADMIN"."HWMSG" >( > "ID" IntegerNOT NULLDEFAULT SERIAL (1), > "TSTAMP" Timestamp, > "MSGLEN" Integer, > "MSG" Varchar (1024) BYTE, > "MSGTY

database crashes

2004-01-15 Thread Stephane . Bredy
Hi all, My database crashes while testing. Here is the diagnosis file "Database errors" VERSION 'Kernel 7.4.3 Build 027-123-048-452' Can any one help, to know if something goes wrong in my configuration, or if there was a problem in SAP DB thanx, Stéphane 2004-01-14 17:25:56 0x5B4 ER

Re: autolog w2k sabdb 7.4.3.30 service

2004-01-15 Thread Stephane . Bredy
Another way, to do that is to is to set auto log on when starting the machine. This let the database starts, and give some times to set auto log to on. the following script set autolog on if needed. but you can just try to set it on without testing ( dbmcli -n %NODE% -d %SID% -u %DBUSEROPE%,%DBPW

Re: autolog w2k sabdb 7.4.3.30 service

2004-01-15 Thread Sap DB
Another way, to do that is to is to set auto log on when starting the machine. This let the database starts, and give some times to set auto log to on. the following script set autolog on if needed. but you can just try to set it on without testing ( dbmcli -n %NODE% -d %SID% -u %DBUSEROPE%,%DBPW

database crashes

2004-01-15 Thread Sap DB
Hi all, My database crashes while testing. Here is the diagnosis file "Database errors" VERSION 'Kernel 7.4.3 Build 027-123-048-452' Can any one help, to know if something goes wrong in my configuration, or if there was a problem in SAP DB thanx, Stéphane 2004-01-14 17:25:56 0x5B4 ER

7.3.0.46 rpm installation fails

2004-01-15 Thread Tilmann Starke
Hi folks, I got an error while installing SAPDB 7.0.3.46 on an experimental SuSE 7.3 linux system: /usr/lib/perl is needed by sapdb-srv... I checked the installation of my perl environment and everything seems to be fine. Finally I tried the .tgz instead the .rpm and now everything is working pe

Trigger, decode

2004-01-15 Thread Dusan Kolesar
Hello I have two tables: CREATE TABLE "ADMIN"."HWMSG" ( "ID" IntegerNOT NULLDEFAULT SERIAL (1), "TSTAMP" Timestamp, "MSGLEN" Integer, "MSG" Varchar (1024) BYTE, "MSGTYPE" Integer,

Re: autolog w2k sabdb 7.4.3.30 service

2004-01-15 Thread Sap DB
Another way, instead of having a task that start the base, is to have a task that set log ON. this let the database instance run faster when starting the machine. just add a scheduled task that runs at startup. <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > we are using SAP

suse8.2, maxdb 7_5_0_5, webdav problem

2004-01-15 Thread Ian Brown
I'm trying to set-up a simple webdav service on my suse box, but am running into some problems. I wonder if anyone can shed some light on them. I have installed the latest binaries (7_5_0_5) and have created a data-source called webdavdb with the users dbm_user and dba_user. The database is onlin

RE: I can not see result of SQL in LOADERCLI and SQLCLI

2004-01-15 Thread Bumes, Hans-Georg
Hello, >I'm working under LINUX now , so I can not use SQLSTUDIO. But LOADERCLI >and SQLCLI often show me a blank result of my SQL statement. loadercli only returns a status message for database queries. http://www.mysql.com/documentation/maxdb/e7/67f6fedd3611d2a97500a0c9449261/frameset.htm if

Re: Insert in a LONG BYTE field, problems

2004-01-15 Thread Dusan Kolesar
Try insert into DATI_BINARI (ID,DATO) VALUES ('one', '01ff0002') string must have values 0..9, a..f It's hexadecimal value vithout x On Wed, 14 Jan 2004 10:44:06 -0800, <[EMAIL PROTECTED]> wrote: I have never used the Long Byte type but my I suspect the problem is a string is not the same as a Byt

RE: Insert in a LONG BYTE field, problems

2004-01-15 Thread Zabach, Elke
ilMes mes wrote: > > if i use LONG ASCII, it work fine with: > insert into tableName (long_field) VALUES (x'10203d') > > If i create a table width a column LONG BYTE, > i do not understand the way to insert a record. > I try: > insert into tableName (long_field) VALUES (x'10203d') > but no no