sagmljohn Posted June 19, 2017 Share Posted June 19, 2017 I'm a report designer and I now need to connect with SQL Anywhere for development. MySQL is all over the forums but, alas, I just get Sybase. We use central and local DBs, but both are connected through TLS. Here is as far as I can get:JDBC Driver: net.sourceforge.jtds.jdbc.DriverUrl: jdbc:jtds:sybase//localhost/[my local SQL Anywhere service name]Sysbase provides some jars in its java directory -- and I've tried jodbc.jar and sajdbc.jar -- I don't think it makes a difference. I only get "connection refused".I'm sure it is security, but I'm not sure if it is some kind or URL parameter or something in the Connection Properties tab that are never talked about. I need to get the TLS type (RSA) and the trusted certificate location to this but I'm not seeing that info anywhere. Doe's anyone else use TLS Sybase connection?Thanks,-- John Link to comment Share on other sites More sharing options...
sagmljohn Posted June 21, 2017 Author Share Posted June 21, 2017 Never mind. I thought I needed all the security info in the URL or as parameters but I kept changing the port # to what I thought the service was using. The default port for jconnect url syntax was what I needed. Also, downloading a conn4.jar failed getting the metadata but just changing the driver path to jdbc3 and using the conn3 that came with out Sybase did the job. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now