AW: Connection via ODBC / QT3-Plugin

Holger Schurig wrote
> 
> > Hello Holger,
> >
> > could you try with user and password in the case they have been
> > created (i.e. probably use TEST/TEST in your case)?
> 
> Yes, that worked, but it's weird. The database was created using this
> snippet:
> 
> -----------------------------------
> echo "create database demo user..."
> _o=`cat <<EOF | dbmcli -d $SID -u dba,dba
> sql_connect dba,dba
> sql_execute CREATE USER test PASSWORD test DBA NOT EXCLUSIVE
> EOF`
> -----------------------------------
> 
> from create_demo_db.sh and here it was specified in lowercase. Also,
in
> ancient times (7.2.4.9 and 7.3.0.24) it worked in lowercase as well.
> 

As with all SQL-statements, everything outside single- and double-quotes
is changed to upper case. Therefore the server 'sees' TEST password
TEST.
If you then connect with CONNECT "test" ... (things inside double quotes
are not changed to upper case) or use a client sending it like this,
this "test" is different to the known TEST inside the server, causing
error 
-4008.
Unfortunately in 'ancient' times we had clients with the misbehaviour of
always-changing to upper or the like. After fixing the bug, people using
this bug/feature have to take care of using the correct writing of their
users/passwords.

Elke
SAP Labs Berlin
> 
> 
> I will change my database driver plugin to first try it with the
> user-supplied case and then with uppercase.
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx