Esko Logo Back to Esko Support
Choose your language for a machine translation:
Skip to end of metadata
Go to start of metadata


Description

Here are settings that were used to successfully setup an External Database Connection using JDBC to a Sybase Database.

Procedure

First, acquire the JDBC Driver for Sybase, which there seems to be multiple of them, but the one that worked in this case was one with a file name of jconn4.jar.

Next, make the following connection settings to establish the connection:

Driver (JDBC): com.sybase.jdbc4.jdbc.SybDriver

Driver File: file://<server>/<share>/jtds-1.3.1-dist/jconn4.jar

ie. file://aeserver/ExampleJobContainer/jtds-1.3.1-dist/jconn4.jar

Database URL: jdbc:sybase:Tds:<IP Address of Database Server>:<Port for Database>?ServiceName=<Name of Database>&USER=<Database User>&PASSWORD=<Database User Password>

ie. jdbc:sybase:Tds:192.168.1.1:2638?ServiceName=MyDB&USER=user&PASSWORD=password

Article information
Applies to

Automation Engine all versions

Created

 

Last revised
AuthorAPRE
Case Number01266076
Contents