How do I connect to my database?

Mobile Data Now uses JDBC drivers to connect to different databases. You can add your own driver in the Settings>>Database Drivers window or use the supplied list of drivers if compatible with your database.

First enter the name of your database, and then add the appropriate URL. Typical examples of URL's shown below.

Note: If you are using an ODBC driver, please see creating a Data Source Name (DSN) in the configuration guide first.

Example:

MySQL

Driver: org.gjt.mm.mysql.Driver (already supplied in driver settings)

URL Format: jdbc:mysql://[host]:[port]/[database]

eg: jdbc:mysql://192.168.1.189:3306/business

JDBC-ODBC Bridge

Driver: sun.jdbc.odbc.JdbcOdbcDriver

URL Format: JDBC:ODBC:[Data Source Name]

eg: jdbc:odbc:northwind

Enter the username and password if required, then click 'Test'. If you receive the message 'Connected!', click the 'OK' button and a view of the tables will load.

A larger list of drivers and URL's is below depending on which driver you use, but your database manufacturer will provide a JDBC driver for your database.

Cloudscape

Driver: COM.cloudscape.core.JDBCDriver

URL Format: jdbc:cloudscape:[database]

Cloudscape RMI

Driver: RmiJdbc.RJDriver

URL Format: jdbc:rmi://[host]:[port]/jdbc:cloudscape:[database]

Firebird (JCA/JDBC Driver)

Driver: org.firebirdsql.jdbc.FBDriver

URL Format: jdbc:firebirdsql:[//[host][:[port]]/][database]

IBM DB2

Driver: COM.ibm.db2.jdbc.app.DB2Driver

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

IDS Server

Driver: ids.sql.IDSDriver

URL Format: jdbc:ids://[host]:[port]/conn?dsn='[Data Source Name]'

Informix Dynamic Server

Driver: com.informix.jdbc.IfxDriver

URL Format: jdbc:informix-sqli://[host]:[port]/[database]:INFORMIXSERVER=[server name]

InstantDB (v3.13 and earlier)

Driver: jdbc.idbDriver

URL Format: jdbc:idb:[database]

InstantDB (v3.14 and later)

Driver: org.enhydra.instantdb.jdbc.idbDriver

URL Format: jdbc:idb:[database]

Interbase (InterClient Driver)

Driver: interbase.interclient.Driver

URL Format: jdbc:interbase://[host]/[database]

Hypersonic SQL (v1.2 and earlier)

Driver: hSql.hDriver

URL Format: jdbc:HypersonicSQL:[database]

Hypersonic SQL (v1.3 and later)

Driver: org.hsql.jdbcDriver

URL Format: jdbc:HypersonicSQL:[database]

Microsoft Access

Driver: com.hxtt.sql.access.AccessDriver

URL Format: jdbc:access:///c:/yourAccessDirectory

Microsoft SQL Server

Driver: weblogic.jdbc.mssqlserver4.Driver

URL Format: jdbc:weblogic:mssqlserver4:[database]@[host]:[port]

Microsoft SQL Server (JTurbo Driver)

Driver: com.ashna.jturbo.driver.Driver

URL Format: jdbc:JTurbo://[host]:[port]/[database]

Microsoft SQL Server (Sprinta Driver)

Driver: com.inet.tds.TdsDriver

URL Format: jdbc:inetdae:[host]:[port]?database=[database]

Microsoft SQL Server 2000 (Microsoft Driver)

Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

URL Format: jdbc:microsoft:sqlserver://[host]:[port][;DatabaseName=[database]]

MySQL

Driver: org.gjt.mm.mysql.Driver

URL Format: jdbc:mysql://[host]:[port]/[database]

eg: jdbc:mysql://192.168.1.189:3306/business

Oracle OCI 9i

Driver: oracle.jdbc.driver.OracleDriver

URL Format: jdbc:oracle:oci:@[Oracle System ID - SID]

Oracle Thin

Driver: oracle.jdbc.driver.OracleDriver

URL Format: jdbc:oracle:thin:@[host]:[port]:[database]

PointBase Embedded Server

Driver: com.pointbase.jdbc.jdbcUniversalDriver

URL Format: jdbc:pointbase://embedded[:[port]]/[database]

PostgreSQL (v7.0 and later)

Driver: org.postgresql.Driver

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

Sun JDBC-ODBC Bridge

Driver: sun.jdbc.odbc.JdbcOdbcDriver

URL Format: JDBC:ODBC:[Data Source Name]

Sybase (jConnect 4.2 and earlier)

Driver: com.sybase.jdbc.SybDriver

URL Format: jdbc:sybase:Tds:[host]:[port]

Sybase (jConnect 5.2)

Driver: com.sybase.jdbc2.jdbc.SybDriver

URL Format: jdbc:sybase:Tds:[host]:[port]