sp_iqaddlogin different in IQ 12.7 and IQ 15

October 7, 2009

The system stored procedure sp_iqaddlogin is different in IQ 12.7 and IQ 15.1

The main difference ist the syntax and it seems that the 15-version might have a bug.

Neither sp_iqaddlogin, nor sp_iqpassword will accept symbols in passwords, such as "=", "%", "!", "+". Strangely the dollar symbol is accepted. The following error message is generated;

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '+' ON line 1

Also a password can not start with a number. The following error message is generated;

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '4' ON line 1

The Sybase documentation contains the recommendation that only 7-bit ASCII characters are used for passwords. These symbols are included in the 7-bit ASCII character set and are acceptable in passwords on IQ 12.7 Servers.

More details can be found here: sp_iqaddlogin - unterschied zwischen IQ 12.7 und IQ 15/ a post on the german blog sybinfo.de.

tags: , , ,
posted in asiq by Frank

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org