The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi, I have a database that was done unload / reload and the individual who made the option selected case sensitive. Now how do I change case sensitive password for off? Set casesentitivepassword = off ??

asked 22 May '13, 09:24

Walmir%20Taques's gravatar image

Walmir Taques
600283143
accept rate: 13%

edited 22 May '13, 21:00

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262


Except in very, very old versions of SQLAnywhere, passwords are always case sensitive: http://dcx.sybase.com/index.html#sa160/en/dbusage/thdbcs.html

permanent link

answered 22 May '13, 09:29

John%20Smirnios's gravatar image

John Smirnios
8.7k377106
accept rate: 40%

1

Where "very, very old" means "v9 or older", IIRC...

Note: When unloading such a very, very old and case-insensitive database into a new version, existing passwords will remain case-insensitive even in the new version (until you modify them, of course) - cf. the help.

(22 May '13, 09:55) Volker Barth
Replies hidden

Thank you. It was older than I cared to research because the oldest version on dcx was case-sensitive. :)

(22 May '13, 09:58) John Smirnios

Well, I regularly have to cope with even much older versions than those very, very old ones...:)

(22 May '13, 10:00) Volker Barth

John is correct except that passwords reloaded from an old database with case-insensitive passwords are still case-insensitive. Once those passwords are changed, they will become case-sensitive.

(22 May '13, 18:09) Graeme Perrow
Replies hidden

It that not what I had already mentioned in my comment? Or have I missed a subtle difference?

(23 May '13, 03:19) Volker Barth
2

Yes, that's exactly what you had in your comment. I just wanted to... um... I thought I should... It was really... OK, I got nothing. Total fail on my part.

(23 May '13, 08:51) Graeme Perrow

Thanks for the clarification - and w.r.t. feeling "very, very old" - been there, too:)

(23 May '13, 09:52) Volker Barth
showing 2 of 7 show all flat view
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×10
×3

question asked: 22 May '13, 09:24

question was seen: 963 times

last updated: 24 May '13, 16:12