From: "David Brady" <[EMAIL PROTECTED]>
Subject: Re: Why MySQL is used instead of MaxDB?
> I've just starting testing MaxDB for some internal reporting tools.
> (And had tried about a year ago with SapDB but gave up.) Though the
> documentation is complete and accurate, it is almost impossible t
Unfortunatelly, seems not all get your answers in documentation, neither WebPTS,
neither in
mailing lists. It's not MaxDB exclusivity. Several open source projects has poor
documentation, specially in infra-structure docs.
IMHO, the MaxDB manuals are fine, since I already have experience with oth
Hello, I'm using MaxDB 7.5.01.00 build 000-101-062-034
my database create with UNICODE = YES
I using for work with database jdbc 7.5.01.00
my connection string connectionString='jdbc:sapdb://ufo/labu?unicode=true'
for binding parameters I call
setInt(1, filter);
setString(2, from);
I concur with all comments made about the Documentation, however, I would
like to write on a positive note here. I'd simply like to say that, where
so many companies are afraid to admit product faults, and give little advice
to their users, the people behind this mailing list go out of their way t
[EMAIL PROTECTED] wrote:
EXPLAIN SELECT field FROM TABLE
SELECT * FROM SHOW
I get my explain output... however, it only works if ODBC Connection Pooling is enabled on the MaxDB ODBC driver. If I turn off ODBC driver
connection pooling, it always fails saying that there is no SHOW table.
Also I'm
Andris Spruds wrote:
The 2nd argument is time in days. Furthermore, you can construct the 2nd
date outside MaxDB.
Example:
SELECT adddate('2003-12-01 00:00:00', 31) FROM DUAL
Thanks...
This won't work since months have different numbers of days. (And, I'd
have to hack at a 3rd party reportin
Hui Zhi wrote:
i can connect to x_server usering SQL studio where i set sq16
defualt. but when i changed sq16 prot to another value, i can't connect
to x_server usering SQL studio.
i don't know the format of server string. is it server:port?
Right. Should your version of SQLStudio
Given a single user supplied date, find all of the data within 1 month
of that date. In databases that support intervals and between, that'd
look something like:
post_date between '2003-12-01 00:00:00' and '2003-12-01 00:00:00' +
interval '1' month
What is the MaxDB equivalent to this? Note
Thanks Daniel for your respons
> Look into the Windows Application Event Log
> Start => Settings => Control Panel => Administrative Tools => Event
Viewer
> for any error messages
There I couldn't become wiser:
The description for Event ID ( 19751 ) in Source ( SAPDB ) cannot be
found. The local
John L. Singleton wrote:
Assuming all things equal, the real breaking point is in the
*documentation*. It needs to be easy to use, easy to understand, and
informative. The problem is, IMHO, that people new to MaxDB find the
documentation system very very difficult. Not just to use, but to
unde
Pratik,
Hello there. In addition to what Alexander has already said, I'll add my
own demented theories into the mix.
In comparison to MySQL, MaxDB is a very different sort of database. I
mean, let's start with the role separation that is enforced in MaxDB:
MySQL has no such granularity. Then t
Edward,
Also keep in mind that you don't have to install two different versions
of the database software(kernels) available. If you want to run several
databases with different storage locations, all while using the same
VERSION of MaxDB, you can do one of two things:
1) When you create your vo
> Although I set the variable LD_ASSUME_KERNEL=2.2.5, I received all the
That's strictly a Linux thing.
> stopped unexpectedly, (view 'Application Event Log')
Look into the Windows Application Event Log
Start => Settings => Control Panel => Administrative Tools => Event Viewer
for any error mess
Hi all
I have tried to install MAXDB on a Windows XP platform without any
success.
Although I set the variable LD_ASSUME_KERNEL=2.2.5, I received all the
times the following error message:
Even creating a database with the DBMGUI was not working. The same
messages appears.
MAXDB has b
> Ideally I would like to have the two databases have
> distinct storage
> in the SAN frame. So my question is can I have two different installs?
>
> For example for the OLTP database I would have the folders as
> /var/opt/oltp/sdb/data, /opt/oltp/sdb/programs and
> /opt/oltp/sd
Hi,
I've got a problem when using MaxDB 7.5.00.08's ODBC driver dynamically
on SuSe 8.1 with iodbc. iodbctest crashes by producing the following
output:
[EMAIL PROTECTED]:/usr/local/libiodbc-3.51.1/samples> ./iodbctest
"DSN=maxdb1;UID=test;PWD=test"
iODBC Demonstration program
This program shows
Hello, all.
I'm having trouble with a brand new instance of 7.5.0.8. The DAYNAME
function always returns null (e.g. SELECT DAYNAME(DATE) FROM SYSDBA.DUAL).
This has not happened with other instances we've created with this version.
Does anyone know how I can track this down and fix it? Rema
Hello,
I have two types of databases which I need to create in maxDB. One
is of the type OLTP and the other a DataWarehouse type. This needs to be
done in a SUN Solaris environment using SANs for datastorage.
Ideally I would like to have the two databases have distinct storage
i
Hello Pratik,
first you should of course also look at the uses of SAP DB, which was the name of
previous versions of MySQL MaxDB
before the cooperation with MySQL took place. You might find more uses by looking for
this too ...
Second, MySQL has a longer history in the open source world, and
Hi Friends,
I am working on a pilot project that
will introduce open source databases in my organisation.
In my search I have found that MySQL
and MaxDB both are open source databases, but MaxDB is being used very
less in comparison to MySQL. If I link this with the fact that MaxDB provides
many
20 matches
Mail list logo
