I'm working on extracting information from a SQLAnywhere 11.0.1 database to migrate them to a more recent solution.
However, I'm running into problems getting a JDBC connection to work.
I've found references to two different JDBC drivers.
However, I am not able to connect using the information from either of these.
I am connecting over a network. I can provide the host, server, database, username, and password. But I am unsure of the connection string format to do so.
And especially when attempting to use the jconn JDBC driver, I am getting an error of other, I assume to be dependent, files missing: "Error connecting to database: (using class com.sybase.jdbc3.jdbc.SybDriver)
no dbjdbc11 in java.library.path"
More information: It looks like my first attempt at including dbjdbc11.dll simply failed.
But I am getting a new error:
Error connecting to database: (using class com.sybase.jdbc3.jdbc.SybDriver)
JZ006: Caught IOException: java.net.ConnectException: Connection timed out: connect
Which I can only assume means I am building the connection string incorrectly.