Network Password Encryption enabled in Sybase DB

Bheeshmaraja, Open the DbVisualizer driver manager, Tools->Driver Manager and select the Driver in the left list you are using. Now take a screenshot of that window and post it here or email to us. I see also that you are using DbVisualizer 5.1.1. That is a really old version and I suggest that you upgrade to the latest 7.1.5 version. Regards Roger support@dbvis.com

Hi, Try do the following: - In the Connection tab, click the lower "Properties" tab. - Click the "Driver Properties" category in the list. - Locate "ENCRYPT_PASSWORD" and change the value from "false" to "true". - Press Apply and re-connect. If it still don't work, please let me know what type of encryption is being setup in the DB server and I will look if there is a solution. Regards Roger

Hi, The error "Login failed" may mean many things. The following explain some situations and possible actions how to resolve the problem. http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/39367;pt=39281/* In your case it seems as if the same error is produced also when failing to authenticate with encryption enabled. What type of encryption is used on the server? Regards Roger

Nagarajan, First I must make you aware that we have no experience with password encryption using the J/Connect JDBC driver, so if the following fail you need to do further investigation on your own. The following page explain how to setup RSA encryption with Sybase: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1500/html/newfesd/newfesd95.htm Based on the article, download the "Bouncy Castle Crypto APIs for Java". Which is the following file: http://www.bouncycastle.org/download/bcprov-jdk16-146.jar Now open DbVisualizer and the Tools->Driver Manager and do as follows: 1) Select the Sybase JDBC driver 2) In the right pane, make sure "User Specified" tab is selected 3) Click the open file button to the right in the tab 4) Locate the bcprov-jdk16-146.jar you just downloaded and open it in the file chooser 5) Now the list of files will list both the driver jar file and the newly loaded bcprov-jdk16-146.jar 6) Close the driver manager window Back in the main window do as follows: 7) In the main window select the database connection for Sybase 8) Click the bottom "Properties" tab 9) Select the "Driver Properties" category in the list 10) Click the green plus icon 11) Enter property name "JCE_PROVIDER_CLASS" 12) Enter the property value "org.bouncycastle.jce.provider.BouncyCastleProvider" 13) Make also sure that the "ENCRYPT_PASSWORD" setting is set to "true" 14) Press Apply Try re-connect. Note that I haven't tested this at all. Regards Roger

Marimuthu, What version of Sybase ASE and the JDBC driver are you using? What steps in the forum post have you tried (it is 5 years old so those steps may not apply to the versions of Sybase and jConnect available today). Regards Roger