I had a crystal report assigment that requires me to work with MaxDB.

And i keep getting this error:

invalid authorization specification;-4008 POS(1) unknown user name/password combination

the fix is to capitalise the password. Or if that doesn’t work, capitalise the username as well.

Order by cant be used in subquery