Driver and connection strings

This topic contains sample driver and connection strings for connecting to a database from the Cleo Harmony, Cleo VLTrader, or Cleo LexiCom application.

ODBC

ODBC data sources are generally configured with an ODBC data source administration tool, for example, in the System DSN tab of Start > Control Panel > Administrative Tools > Data Sources (ODBC). See the appropriate database/operating system documentation for further details.

Note: Appropriate ODBC configuration is required for each computer that will access the transfer database using Cleo Harmony, Cleo VLTrader, or Cleo LexiCom.

Driver String

sun.jdbc.odbc.JdbcOdbcDriver

Connect String

jdbc:odbc:odbcname

MS Access database

Driver String

sun.jdbc.odbc.JdbcOdbcDriver

Example Connect String

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//fi lesvr/sharename/db/vltdb.mdb

MySQL Connector/J

Driver String

com.mysql.jdbc.Driver

Connect String

jdbc:mysql://[host][,failoverhost...][:port]/
[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...

Example Connect String

jdbc:mysql://myhost:3306/vltdb

Note: For older versions of the MySQL driver the connection string was:

jdbc:mysql://myhost:3306/vltdb/

Microsoft SQL Server

Driver String

com.microsoft.sqlserver.jdbc.SQLServerDriver

Connect String

jdbc:sqlserver://[host]:[port];databaseName=[database];
selectMethod=[selectmethod];
sendStringParametersAsUnicode=[sendStringParametersAsUnicode]

Example Connect String

jdbc:sqlserver://myhost:1433;databasename=vltdb

Example Connect String (with Windows Authentication):

jdbc:sqlserver://myhost:1433;databasename=vltdb;integratedSecurity=true

Note: For Windows Authentication, place the appropriate sqljdbc_auth.dll for your database and platform into the .../VersaLex directory.

Oracle

Driver String

oracle.jdbc.driver.OracleDriver

Connect String

jdbc:oracle:<drivertype>:@<database>

Example Connect String

jdbc:oracle:thin:@myhost:1521:vltdb

IBM DB2

Driver String

com.ibm.db2.jcc.DB2Driver

Connect String

jdbc:db2://[host]:[port]/database

Example Connect String

jdbc:db2://myhost:50000/vltdb

PostgreSQL

Driver String

org.postgresql.Driver

Connect String

jdbc:postgresql://[host]:[port]/database

Example Connect String

jdbc:postgresql://myhost:5432/vltdb