Using a Sybase 10 Database with the Sybase 11.01 Server

Follow these steps to work with a Sybase 10 database if you are using the Sybase 11.01 server.

  1. Determine which JVM your tomcat installation is using.
    To do so, copy:
    C:/Program Files/SQL Anywhere 11/(BIN64 or BIN32)/dbjdbc11.dll
    to
    C:/Program Files (or x86 if using 32 bit JVM)/Java/(Java version in use)/bin/dbjdbc11.dll.
  2. Copy C:\Program Files\SQL Anywhere 11\Java\sajdbc.jar into .../archibus/WEB-INF/lib/.
  3. Remove jodbc.jar and jconn3.jar from that folder.
  4. Modify line 676 in afm-config.xmlas follows:
    <jdbc driver="sybase.jdbc.sqlanywhere.IDriver"
    url="jdbc:sybase:Tds:localhost:2638"
    connectFormat="1"
    transactionIsolationLevel="1"/>
    <sql>
  1. Modify afm-projects so that your JDBC strings look like the following, replacing server_name with the name of your Sybase 11 instance:
    <jdbc url="jdbc:sqlanywhere:uid=afm;pwd=afm;eng=server_name" />