jaydebeapi icon indicating copy to clipboard operation
jaydebeapi copied to clipboard

Connecting to ASE using Jconnect drivers

Open SybaseWrangling opened this issue 6 years ago • 1 comments

Hi, I understand that its not mentioned in the supported DBMS list, but I am having issues connecting to ASE using the native Jconnect drivers.
Connection properties:

conn = jdbc.connect("com.sybase.jdbc4.jdbc.SybDriver",
                    "jdbc:sybase:Tds:10.1.1.1:5000/MyDB",
                    {'user': "SybaseWrangling", 'password': ""},
                    'C:\\Sybase\\jConnect-7_0\\classes\\jconn4.jar')

This is returning the following error

java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

(Yes, I have checked the URL, username and password in other apps that use Jconnect successfully) Can anyone advise if there is an issue, or whether ASE/Jconnect is not supported?

Thanks

SybaseWrangling avatar Oct 15 '19 03:10 SybaseWrangling

Possible Solution: https://github.com/baztian/jaydebeapi/issues/162#issuecomment-1426289685

js-lowes avatar Feb 10 '23 20:02 js-lowes