Skip to Content
avatar image
Former Member

JDBC Connection to SQLAnywhere 11.0.1

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.

  1. jconn
  2. sajdbc

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"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 15, 2016 at 07:11 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tim,

      I was wondering if you could try this:

      Connection con = DriverManager.getConnection("jdbc:ianywhere:driver=SQL Anywhere 11;uid=dba;pwd=sql;eng=server_name;dbn=db_name;host=host_or_ipaddress:port" );

      Best regards,