Adaptive Server 要求在 Oracle SQL Developer Tool 中对网络上的登录密码进行加密 [英] Adaptive Server requires encryption of the login password on the network in Oracle SQL Developer Tool

问题描述

在 Oracle SQL 开发人员工具中连接到我的数据库时出错

I am getting error while connecting to my database in Oracle SQL developer tool

"Adaptive Server requires encryption of the login password on the network"

可以在工具中设置任何参数来修复它或任何其他建议吗?

Can any paramater be set in the tool to fix it out or any other suggestions ?

推荐答案

我们应该传递 ENCRYPT_PASSWORD=true:示例蟒蛇:

we should pass the ENCRYPT_PASSWORD=true: example python:

import glob
driver_name='com.sybase.jdbc4.jdbc.SybDriver'
driverpath=r"C:\Users\RameshPonnusamy\AppData\Roaming\DBeaverData\drivers\drivers\sybase\jconnect\jconn4.jar"        
import jaydebeapi
jclassname=driver_name
url="jdbc:sybase:Tds:{h}:{pr}".format(h=host,pr=port,db=database)
driver_args={'user': username, 'password':password,
                 'database': database,
                 'ENCRYPT_PASSWORD':'true'}
jars=glob.glob(driverpath)
conn = jaydebeapi.connect(jclassname=jclassname,url=url, driver_args=driver_args, jars=jars)

如果您使用的是 IDE(例如:Dbeaver)将 ENCRYPT_PASSWORD 参数更新为 true

If you are using IDE(Ex:Dbeaver) Update ENCRYPT_PASSWORD parameter as true

right click on connection
 -->edit_connection(if it is already saved)
    -->Driver Properties-->click on value column cell of ENCRYPT_PASSWORD 
    ***type true*** and click ok

这篇关于Adaptive Server 要求在 Oracle SQL Developer Tool 中对网络上的登录密码进行加密的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！