About ODBC connection orcal, user name, password, and case sensitive issues

Source: Internet
Author: User
Tags odbc connection
In the previous version of Oracle, your username password is case insensitive, but in 11g, the case of the database default password is sensitive, so we know the fact that JDBC will turn it into uppercase when it gives the Oracle password, it's a strange thing.

You may say: Well, then I will set the password to uppercase well, haha haha, you are finished, you know some programs, in the link Oracle, will be the password to lowercase, it is not very strange, very faint dish?

The password in the Oracle database is case-sensitive facts generations, unified, you will encounter many will change the password to change the wonderful program, then how to do? In fact, it is simple to remove the Oracle password capitalization sensitivity setting:

Alter system set Sec_case_sensitive_logon=false

About ODBC connection orcal, user name, password, and case sensitive issues

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.