BorlandTalk.com

Jos de Bruijn · Guest

Hi,

I've created a login on my sql server:
user = 'NewUser'
password = 'ABC'
but when I try to logon with this user (using ado) it doesn't matter if my
password is 'abc' or 'ABC' both passwords will be accepted. Is this a
setting of ADO of is it a setting on my SQL server? The server (SQL2000) is
in mixed mode.

Thanks,

Jos

Del M · Guest

Sql Server works that way. By default all comparisons are set to be not case
sensitive. If you change it to be case sensitive then
'select col1, col2 from tableX where name = 'jones' ... would not work
unless the name was stored exactly that way. Passwords are stored in a
system table encrypted and so they are compared by the db engine just as all
other data is.

If you want tricky passwords, then create a user database and setup
passwords there to be compared .. like 'D3$aN#' .

I think ... :-)