Previous Topic  Next Topic

Example 3: Via SQL Server

This topic introduces how to set up a JDBC Connection via the SQL Server.

Assume that:

• You have already installed the SQL driver, and have appended the archive files of the driver to the ADDCLASSPATH variable in the file setenv.bat in <designer_install_root>\bin.
• The SQL Server is with the following information:

  Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
  URL: jdbc:sqlserver://db35.jinfonet.com.cn:1433;DatabaseName=test
  User: test
  Password: 1234

• A catalog has been created with a default data source.

Take the following steps to set up a connection which connects Logi JReport Designer to a database via SQL Server:

1. Start Logi JReport Designer and open the catalog.
2. In the Catalog Manager, right-click the node of the default data source and select New JDBC Connection from the shortcut menu. Select JDBC in the Select Connection Type dialog.
3. In the Get JDBC Connection Information dialog, enter the JDBC driver class name com.microsoft.sqlserver.jdbc.SQLServerDriver in the Driver text field.
4. In the URL text field, specify the URL as jdbc:sqlserver://db35.jinfonet.com.cn:1433;DatabaseName=test.
5. Input the user name test and password 1234 respectively.

   

6. Select OK to set up the connection.

Previous Topic  Next Topic