Previous Page Next Page

Example 5: Via Informix

Assume that:

• You have already installed Informix 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 Informix database server is with the following information:

  Driver: com.informix.jdbc.IfxDriver
  URL: jdbc:informix-sqli://qad02.jinfonet.com.cn:9090/DataType:INFORMIXSERVER=ol_informix1210_1
  User: jrDesign
  Password: Test1234

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

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

1. Start 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. Click JDBC in the Select Connection Type dialog.
3. In the Get JDBC Connection Information dialog, enter the JDBC driver class name com.informix.jdbc.IfxDriver in the Driver text field.
4. In the URL text field, specify the URL as jdbc:informix-sqli://qad02.jinfonet.com.cn:9090/DataType:INFORMIXSERVER=ol_informix1210_1.
5. Input the user name jrDesign and password Test1234 respectively.

   

6. Click OK to set up the connection.

Previous Page Next Page