Delete Takes a very long time

2004-05-04 Thread MaxDB - Mailing List
Hello, I have my app almost complete on MaxDB. I have just run into a major snag and would appreciate any help you can offer. I have a table "Files" that has about 400,000 rows If I run queries like 1) SELECT * FROM FILES WHERE FILE_NAME = "THISFILE.TXT" OR 2) SELECT * FROM FILES WHERE FILE_

Install of 7.5.0.11 on RH WS 9.0.3.EL: Cannot switch to sdb

2004-05-04 Thread Ross Rankin
I am doing a clean install of MaxDB and cannot get past this error during the installation. I let the install program create the user and the group, used all the default paths and it still will not run. A search on here and Google has turned up nothing. Any ideas: Dbmsrvctrl start: cannot s

Error when uploading picture

2004-05-04 Thread zaq quallesqy
Previous problem were solved. But another is coming, when I'm trying to writing a picture to database. I got warning : "ERROR [HY000][SAP AG][SQLOD32 DLL] General error" Anybody can tell me what the warning means? Thanks. === English is not my 1st language ===

Upgrade from 7.5.0.8 to 7.5.0.11 - tarball to RPM

2004-05-04 Thread Ken Snider
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Two questions, both related: 1 - What is the procedure to upgrade from 7.5.0.8 to 7.5.0.11? 2 - Since RPM's are now available for 7.5.0.11, what is the procedure to go from 7.5.0.8 tarball, to 7.5.0.11 RPM's? Thanks! - -- Ken Snider -BEGIN PGP SIGNA

SQLDBC status / sample code for win32?

2004-05-04 Thread iml-sapdb
Is SQLDBC out of beta, supported interface? Is there a C / C++ example program to demonstrate how to do a simple SELECT? Prefer for win32 / Microsoft compiler. Anyone have code to share? Thank you. Stephen Gutknecht Full time traveler currently in Dallas, Texas USA -- MaxDB Disc

RE: VB.Net and MaxDB

2004-05-04 Thread Koetter, Thomas Theodor
Hi Massimo > -Original Message- > From: Massimo Renzi [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 4. Mai 2004 11:36 > To: Milis MaxDB > Subject: R: VB.Net and MaxDB > > > Hi all, > sorry If I say this: > why SAPDB dont develop Ado.Net Native driver? > I think that a lot of people will us

RE: Problem with MAXDB ODBC

2004-05-04 Thread Koetter, Thomas Theodor
Hi Albert > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 4. Mai 2004 12:27 > To: [EMAIL PROTECTED] > Subject: Problem with MAXDB ODBC > > > Hallo ! > > Strange problem with maxdb odbc connections. > > I installed maxdb, databasemanager and sq

RE: LIMIT parameter

2004-05-04 Thread Schroeder, Alexander
Hello Edward, no, MaxDB does not have a LIMIT statement. You may want to search the mailing list archive for previous threads about this and possible workarounds. Regards Alexander Schröder SAP DB, SAP Labs Berlin > -Original Message- > From: Pius, Edward [mailto:[EMAIL PROTECTED] > Se

LIMIT parameter

2004-05-04 Thread Pius, Edward
Hello, Is it possible to use the LIMIT parameter in maxDB? When I try to use this in my SQL, it complains about "Invalid keyword or missing delimiter". This is my SQL statement "select * from meter_interval_consumption limit 10" Edward Pius.

LIMIT parameter

2004-05-04 Thread Pius, Edward
Hello, Is it possible to use the LIMIT parameter in maxDB? When I try to use this in my SQL, it complains about "Invalid keyword or missing delimiter". This is my SQL statement "select * from meter_interval_consumption limit 10" Edward Pius.

Re: Bug in JDBC Driver: Wrong result for IS_NULLABLE in MetaData when a DEFAULT value was specified

2004-05-04 Thread maxdb
Hello Alexander Many thanks, seems to work perfect. Thanks a lot! Gabriel Matter Schroeder, Alexander wrote: Hello Gabriel, attached is the JDBC driver that fixes the problem (MaxDB JDBC Driver, MySQL MaxDB, 7.5.1Build 000-000-002-633). Regards Alexander Schröder SAP DB, SAP Labs Berlin --

RE: problem in bringing up an instance to admin state

2004-05-04 Thread Mensing, Joerg
Hi, > -Original Message- > From: Krishna, Tupurani Ravi (STSD) [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 4. Mai 2004 12:37 > To: [EMAIL PROTECTED] > Subject: problem in bringing up an instance to admin state > > > > > > Hi, > >I have installed SAPDB 64

problem in bringing up an instance to admin state

2004-05-04 Thread Krishna, Tupurani Ravi (STSD)
Hi, I have installed SAPDB 64 bit (sapdb-all-hpux-64bit-hppa-7_4_3_31) on HPUX 11.11 64 bit version. I have started the x_server. After that i have given the following commands to create an instance test # ./dbmcli db_create -s test dbm,dbm root,data*pr0 OK # .

Problem with MAXDB ODBC

2004-05-04 Thread A . Beermann
Hallo ! Strange problem with maxdb odbc connections. I installed maxdb, databasemanager and sqlstudio on my local windows xp pc and did some testing. My application connects via system-dsn MAXDBLOKAL STORE SQLSTRINGCONNECT('dsn=maxdblokal;port=7210;uid=DBA;pwd=DBA;DATABASE=BWNE U') TO verbindung

R: VB.Net and MaxDB

2004-05-04 Thread Massimo Renzi
Hi all, sorry If I say this: why SAPDB dont develop Ado.Net Native driver? I think that a lot of people will use it and will choice MaxDb. ODBC it's very slow, so cause I develop for Windows Platform I'll never use MaxDb. bye max -Messaggio originale- Da: Schroeder, Alexander [mailto:[E

DBA login problem after restore

2004-05-04 Thread AF
Hi ! I've been having problems getting DB restoration working correctly. After much trial and error, I got as far as getting all data in with the following: dbmcli -s db_create $DBNAME $DBMUSER,$DBMPWD

Re: AW: How do I write my connection string to avoid ODBC connection prompting

2004-05-04 Thread Gustav Brock
Hi H anonymous I believe Peter is on the track here. Your string should contain no quotes and must contain all connection info as SERVERBASE, DATABASE etc.: ConnectString = "DSN=contact;;uid=mylogid;pwd=mypass;" The trailing semicolon may also be needed. /gustav > for linking tables in Access