Example Connections

This section shows some sample connection commands and explains how they work.

OpenSQLConnection[ JDBC[ "mysql",
"databases:1234/conn_test"], Username -> "test"]

In this example you connect to a MySQL database using the built-in driver, use the database running on computer named databases on port 1234, connect to the database called conn_test, and use the username test.

OpenSQLConnection[ JDBC[ "com.mysql.jdbc.Driver",
"databases:1234/conn_test"], Username -> "test"]

In this example we connect to the same MySQL database as in the previous example, but this time we use the driver com.mysql.jdbc.Driver.