Connecting to Informix DB

2006-03-15
2013-04-25
  • Andy Feltmate
    Andy Feltmate
    2006-03-15

    I'm a newbie to OpenReports Designer, and here is what I'm trying to do.

    I have an informix db located on a debian linux machine. I am trying to run Openreports designer on a Windows XP machine and connect to the database.

    When I enter the information for the database it doesn't give me an error, but when I run the report wizard and try a simple query it gives me the error:
    WARN GUIUtil - java.sql.SQLException: Database not selected yet.

    Here are my settings for the database:

    Name: Inftest
    Drive: com.informix.jdbc.IfxDriver
    URL: jdbc:informix-sqli://server:1526:informixserver=local_se
    Username: dbuser
    Password: ****

    The query I'm trying to run is a simple "Select * from table;"

    I'm assuming my URL is incorrect, how would I go about specifying the database?

    Anyone?

    Andy

     
    • Sicantik
      Sicantik
      2007-02-14

      Hi Andy, here you should add :

      URL: jdbc:informix-sqli://server:1526/databasename:informixserver=local_se

      fill databasename with your database name after informix port.

      Regards,

      Iman