Informix Genero Studio (at least with V2.41 and earlier versions) contains several nice demos, which are loaded and run as Genero projects. Using the out-of-the-box configuration for all of these demo projects, all database access with be performed with the SQLite database that is shipped with Genero Studio. Now SQLite is a nice database for cell phones and demos, but most of us want to build and run demos against our "real" Informix database.
I didn't find any documentation that describes how to reconfigure the database settings and so played some with the projects and determined how to do this. Others may be interested as well, so I'll describe the process here.
There are two databases used in the demos officestore and custdemo. You'll want to create the two empty databases in your Informix server using dbaccess or your favorite SQL utility.
Load the demo project DSConfig. The demo projects are found on the "Projects" tab on the Welcome Page.
Run the DSConfig application (this should be the highlighted/default) one in the project:
In the application's dialog box, configure the officestore information for your Informix server. Here are the settings for my server:
Select the Informix driver from the list. The format for the source entry is <database name>@INFORMIXSERVER.
From here you can use the "Test" button to test the connection. When you hit the "Ok" button, the project configuration gets updated. Now when you run the OfficestoreSetup project (loaded the same way the DSConfig project is loaded), it will load the demo data into your officestore database on your Informix server. The other demo projects that use officestore will use this same database.
If you had a problem in the Test step above, you also need to set the Informix environment variables for your Genero Studio session. In the lower right corner of the Genero Studio window, you will see the display client being used as well as a tool icon to configure the runtime environment. I am using the Genero Desktop Client. The configuration button in circled in red:
Select the configuration button and you will see the Genero Configuration Management
screen. Select the environment set for DB-Informix and deselect the one for DB-SQLite:
Highlight the "DB-Informix" environment set and select the "Configure" button. In the resulting Genero host management dialog, again select the DB-Informix environment set. You will see the Informix environment variables in the right side of this window. Set $INFORMIXDIR, $INFORMIXSERVER and $INFORMIXSQLHOSTS.
When you apply these changes, you should be able to successfully.rerun your OfficestoreSetup application.
Now that you have loaded data into your officestore database, repeat the process for the custdemo database by re-running the DSConfig project to configure the custdemo database configuration. Run the CustdemoSetup project to load the data into your Informix custdemo database.
Have fun playing with the Genero demo programs!