Date insertion

2004-03-22 Thread Paul W. Reilly
MaxDB Community Member, I have been trolling through all the post and documentations and am not having much luck with finding the proper way to handle date insertion. When I do this: insert into temp_x (date_) values ('2004-10-04') it works fine, but I would prefer to handle dates in an Oracle fa

Re: [BUG] ODBC based apps cannot connect to SAPDB

2004-03-22 Thread Sven Köhler
- Figure out why the ODBC-driver doesn't want to connect to the MaxDB Server since the error now occures with both ODBC-driver installations: the SQLSTUDIO-specific installation the the general standalone installation. OK, the resolution is to enter the database-name in uppercase-letters. I thin

Re: SAP DB/MAX DB with Mono??

2004-03-22 Thread Daniel Dittmar
Marcin P wrote: I wonder I anyone have managed to connect to SAP DB from Mono framework?? There exists one project to support SAP DB / MAxDB from Mono: http://www.bytefx.com/Products.aspx I'm not sure what the state of the project is, tough. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMA

Re: varchar(n) question.

2004-03-22 Thread Daniel Dittmar
Christoph Weser wrote: create table testtable ( test varchar(100) not null, ) The question: Will this 100 Byte be allocated (or something like that) before Usage, or is it really complete dynamical, like the name suggests? In the theoretical case, that in every row, only the first 10 bytes

Re: MSI Installer

2004-03-22 Thread Daniel Dittmar
Cedric Cuche wrote: Hello, I want to know where I should look at (in the source code) to make a MSI compatible install/uninstall script for SapDB 3.4 that does the same as the install scripts from the command line. For SAP DB 7.4.03.31, the sources for the installer part can be downloaded from

Re: unable to change state = online

2004-03-22 Thread Daniel Dittmar
Shah, Niraj wrote: I have downloaded MaxDB and working with Database Manager for Windows. I can't change database state to "online" but can change to "Admin". When I try to change from Admin to Online, I am getting following error... "-24988 sql error [db_online -f]; -, connection broken". A c

Re: [BUG] ODBC based apps cannot connect to MaxDB

2004-03-22 Thread Sven Köhler
oops, damn, should have been MaxDB instead of SAPDB in the subject -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[BUG] ODBC based apps cannot connect to SAPDB

2004-03-22 Thread Sven Köhler
Hi, it's me again with the old nice sweet litte bug that's internally called with the short name "ODBC driver reports error '709 connection refused' although the ODBC driver can establish a TCP/IP-connection and get's a 'rejected bad connect packet' message from the server that you can easily

Loadercli dies with error -25801, crashes remote DB

2004-03-22 Thread Thorn Roby
I'm trying to replicate a 500MB 7.4.03.17 Solaris 9 database to Maxdb 7.5.00.08 on Redhat 9.0 Linux. I believe that I can't use backup/restore because of the byte order issue. I am running loadercli on the Maxdb machine, using the following script: // USE USER dba dbapass SERVERDB mydb ON myhost

unable to change state = online

2004-03-22 Thread Shah, Niraj
Hi; I have downloaded MaxDB and working with Database Manager for Windows. I can't change database state to "online" but can change to "Admin". When I try to change from Admin to Online, I am getting following error... "-24988 sql error [db_online -f]; -, connection broken". Can someone help m

Waiting for Transactions to finish

2004-03-22 Thread John L. Singleton
Hello List, Quick question: I read in this posting here: http://archives.neohapsis.com/archives/dev/sapdb/2003-q2/0459.html that the difference between db_offline and db_stop was that db_offline broke transactions first, whereas db_stop was like "pulling the plug." However, I did some tests a

MSI Installer

2004-03-22 Thread Cedric Cuche
Title: MSI Installer Hello, I want to know where I should look at (in the source code) to make a MSI compatible install/uninstall script for SapDB 3.4 that does the same as the install scripts from the command line. Does it already exist such script for MaxDB or SapDB? Any help will be we

migrate from 7.4 to MaxDB => 903 I/O Error

2004-03-22 Thread Gerd König
Hi, we're going to migrate from SapDB 7.4.3.31 to MaxDB, but we're running in troubles. In 7.4 we created a backup via: backup_media_put mybackup $BACKUPFILE FILE DATA 0 8 YES util_connect dbm,0okmCDE3 backup_start mybackup MIGRATION DATA and restored this with: after a couple of minu

RE: DBIdentifier of DataVolume

2004-03-22 Thread Hahn, Uwe
Probably your target database contains log from an earlier installation. If you only recover the data area into the target instance log and data are not compatible to each other. You have to reinstall the target instance with the source data backup and you must not restart it until you have recove

RE: Question about locks

2004-03-22 Thread José Rómulo Elías Contreras
Hi: I am confused, because I am agree with you. Each connection is make with an isolation level 0. The problem here is: - T2 can assign an EXCLUSIVE LOCK to the table row R1 before update (it is OK). - But when I tried to update R1 with the next statemen in java: // (

DBIdentifier of DataVolume

2004-03-22 Thread Bjoern . Arne . Ramann
Hello, we use spdb 7.4.3.17 and make an import/recovery from an db which is from an other system. after the recovery (way=meduim), the db dont start no more. RestartArchiveLog: LogAndDataIncompatible 2004-03-22 13:27:43 21676 ERR60 Log RESTART ERROR '3800' => SHUTDOWN IS FORCED 2004-03-

RE: varchar(n) question.

2004-03-22 Thread Zabach, Elke
Christoph Weser > > Hello! > > Hope this question isn't answered 1000-times, but I haven't > found anything > in the list archive. > > I create the test table: > > create table testtable ( >test varchar(100) not null, > ) > > The question: > Will this 100 Byte be allocated (or someth

varchar(n) question.

2004-03-22 Thread Christoph Weser
Hello! Hope this question isn't answered 1000-times, but I haven't found anything in the list archive. I create the test table: create table testtable ( test varchar(100) not null, ) The question: Will this 100 Byte be allocated (or something like that) before Usage, or is it really com

Re: .NET and ODBC Drivers - error -4008

2004-03-22 Thread Marcin P
Hello Thomas, Thank you very much for your immediate answer. I must have overlooked the post you mentioned. Anyway - after I changed my password from mypassword to MYPASSWORD everything works smoothly. Thanks a lot :-) Tschuess, Marcin Pytel Uzytkownik "Koetter, Thomas Theodor" <[EMAIL PROTECTE

RE: Undocumented error message Command inactivity timeout

2004-03-22 Thread Zabach, Elke
Claus-Thomas Buhl wrote: > > Zabach, Elke schrieb: > > > LOCKS can never be the reason for a SESSION TIMEOUT > > So what could be the reasons for a SESSION TIMEOUT? > What could make the execution of an SQL statement wait for > (more than) 15 minutes? > Good question, ask your application, t

RE: Question about UPDATE query syntax

2004-03-22 Thread Zabach, Elke
Andris Spruds wrote: > > Hello MaxDB list, > > I have problems understanding the correct syntax of a > particular UPDATE > statement. The query, which seems a pretty standard query for > me, does not > work: > > 'update ar_comments c set c.author = (select u.username from > users u where > u.

RE: .NET and ODBC Drivers - error -4008

2004-03-22 Thread Koetter, Thomas Theodor
Hi Marcin > -Original Message- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Marcin P > Sent: Montag, 22. März 2004 08:36 > To: [EMAIL PROTECTED] > Subject: .NET and ODBC Drivers - error -4008 > > > Hi! > I just wanted to drop you a line that I've noticed strange behaviour > of ODBC d

RE: TASKING error

2004-03-22 Thread Mensing, Joerg
Hi Ajit, this error message indicates, that you are using a modern CPU architecture capable of internal opcode reordering. That means the CPU is able to reorder the assembler statements after they were transported into its CPU pipelines. So even if your code seems to have the right order, the CP