Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

TypeDriverURL syntax
MySQLcom.mysql.jdbc.Driverjdbc:mysql://hostname:port/databaseName
PostgreSQLorg.postgresql.Driverjdbc:postgresql://host:port/database
Microsoft SQL Servernet.sourceforge.jtds.jdbc.Driverjdbc:jtds:sqlserver://server:port/databaseName
ORACLEoracle.jdbc.driver.OracleDriverjdbc:oracle:thin:@hostname:port Number:databaseName
DB2COM.ibm.db2.jdbc.net.DB2Driverjdbc:db2:hostname:port Number/databaseName
Sybasecom.sybase.jdbc.SybDriverjdbc:sybase:Tds:hostname: port Number/databaseName

If you are using a datasource like an LDAP or an Active Directory you using Microsofts Active Directory which uses a MS SQL database and you want to connect to that database via PocketQuery you might need to specify parameters like a domain name in your JDBC URL. For  For example, if you are using the jTDS JDBC driver your URL could look like this:

...