Skip to Content
avatar image
Former Member

How to connect from "Oracle SQL Developer" to "SQL Anywhere 16" DB?

Test Connection from "Oracle SQL Developer" was successful but get the DB via button "Datenbank abrufen" failed with error:

"Status: Nicht erfolgreich -SQL Anywhere Error -110: Item 'jtds00001' already exists"

any idea?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • The error -110 cause is "You attempted to create a file, table, view, column, constraint, foreign key, or publication with the same name as an existing one.". The object jtds00001 is not a SQL Anywhere object - a google search suggests it is related to jTDS. Are you using jTDS? Have you considered the SQL Anywhere JDBC driver or jConnect?

  • Former Member

    You are right, I'm using jTDS to connect to SQL Anywhere because it was the only I found for SQL Anywhere.

  • You did not post the version of SQL Anywhere you are using. I have provided documentation links that outline the JDBC connectivity options for currently supported versions:

    SQL Anywhere 16

    SQL Anywhere 17

    The jConnect driver is not shipped with SQL Anywhere.

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 04 at 03:33 PM

    I use "SQL Anywhere 16" on Linux.

    On this installation a "jconn4.jar" file is available which I copied to "Oracle SQL Developer" (Win) and set it as JDBC driver within but without success which means adding a further connection to "SQL Anywhere"-Sybase was not possible as no tab is shown in the "Add connection" menu of the "Oracle SQL Developer" !

    Using jtds-1.3.1.jar always show two tabs for SQL Server and Sybase.

    Maybe it is the wrong jonn4.jar file ...

    Add comment
    10|10000 characters needed characters exceeded

    • It is not clear that SQL Developer supports any third party JDBC - it appears to support mySQL and jTDS only. There is mixed messages about jTDS use with SQL Anywhere. In theory, jTDS should work with SQL Anywhere unless it is executing specific statements that are not valid in SQL Anywhere.

      The SQL Anywhere administration and IDE is SQL Central.

  • avatar image
    Former Member
    Jan 04 at 03:37 PM

    checking "jconn4.jar" shows:

    # java -jar ./SYMCOpsCenterServer/lib/jconn4.jar
    jConnect (TM) for JDBC(TM)/16.0 PL04 (Build 27080)/P/EBF23431/JDK 1.6.0/jdbcmain/OPT/Mon Sep 1 05:57:43 PDT 2014

    Add comment
    10|10000 characters needed characters exceeded