Driver and connection strings

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.

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, choose the appropriate x64 or x86 .dll file from the MSSQL JDBC connection archive (for example, /sqljdbc_13.4/enu/auth/x64/mssql-jdbc_auth-13.4.0.x64.dll) for your database and platform and place it in the .../VersaLex directory. Restart VersaLex to apply the change.

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