Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Ī typical JDBC URL is the following: jdbc:mysql:User=myUser Password=myPassword Database=NorthWind Server=myServer Port=3306 Īfter establishing a connection, the wizard will close and the connection will be available in the connections panel. RazorSQL is apparently configured to automatically convert 65535 data. Database Specific Help: Detailed information on how to connect for each type of database supported by RazorSQL. If not set, tables from all databases will be returned.įor assistance in constructing the JDBC URL, use the connection string designer built into the MySQL JDBC Driver. Optionally, Database can be set to connect to a specific database. to DB2 from wizards and query DB2 data from the GUI in the RazorSQL database. If IntegratedSecurity is set to false, then User and Password must be set to valid userĬredentials. Configuring an IBM DB2 Database Connection To configure the support for the.
The Server and Port properties must be set to a MySQL server. The JDBC URL begins with jdbc:mysql: and is followed by a semicolon-separated list of connection properties. (This property can also be set in the JDBC URL.) Driver Class: Set the driver class to.Use the JDBC driver to make the connection. Driver Location: Set this property to the path to the lib subfolder in the installation directory. Connect to the database using the database name, user name, and password.In the Connection Wizard that appears, set the following properties:.Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.This article shows how to connect to MySQL using wizards in RazorSQL. The CData JDBC Driver for MySQL enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools.
0 kommentar(er)
