LR 连接oracle时,SQLState=28000 ODBC ORA ORA-01017;: Invalid username/password; logon denied
来源:互联网 发布:萧亚轩事业 知乎 编辑:程序博客网 时间:2024/06/06 07:52
LR连接oralce 时报错,前提从sql server客户端可以正常登陆:
问题重现:
1. 检查数据库驱动: C:\Windows\SysWOW64\odbcad32.exe
2. 检查用户 DSN -> 添加,选择 ORACLE IN ORAHOME90 , 在oracle odbcad32 driver configuration填写数据库连接配置;
3. 点击 test connection 时,提示:SQLState=28000 ODBC ORA ORA-01017;: Invalid username/password; logon denied
问题原因之一:
1. oracle 中用户名密码是大小写不敏感的(用户名或密码可能存在小写情况)
解决方案:
去除oracle的密码大写敏感设定:
alter system set sec_case_sensitive_logon=false
0 0
- LR 连接oracle时,SQLState=28000 ODBC ORA ORA-01017;: Invalid username/password; logon denied
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017 invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017:invalid username/password; logon denied
- ORA-01017 invalid username/password;logon denied
- ORA-01017: invalid username/password; logon denied
- oracle 10g dblink连接11g ORA-01017 invalid username/password;logon denied
- ORA-0107 invalid username/password;logon denied
- sqlplus登录oracle时ORA-01017: invalid username/password; logon denied的错误
- sqlplus登录Oracle时ORA-01017: invalid username/password; logon denied的错误
- sqlplus登录Oracle时ORA-01017: invalid username/password; logon denied的错误
- sqlplus登录Oracle时ORA-01017: invalid username/password; logon denied的错误
- 关于自定义UITableViewCell布局点击Cell消失的问题
- 字符串匹配的KMP算法
- Oracle笔记(六) 多表查询
- UITableViewCell左侧会有默认15像素的空白
- android百度定位后显示在地图上点击弹出气泡
- LR 连接oracle时,SQLState=28000 ODBC ORA ORA-01017;: Invalid username/password; logon denied
- NSUnknownKeyException异常
- 黑马程序员——Foundation框架结构体、字符串、数组
- POJ 1088 滑雪 DFS
- hdu3695(AC自动机)
- Mongdb安全和认证
- 属性传递
- HDU 5387 Clock(分数类+模拟)
- iOS开发UI中懒加载的使用方法