Install Informix on Windows 9.4

1. Download to FTP Server
   Informix.Dynamic.Server.v9.4.Enterprise.Edition-SHOCKiSO.zip
2. Extract
   There will be multiple compressed NSS to be cut, and then decompress the shkif9420.rar. A "infds94w. bin" file will be decompressed.
3. Install virtual
   After the Drive drive daemon tools, you can find the executable program of setup.exe in the Virtual Drive by using the infds94w.binfile.
4. Double
   Set setup.exe to start installation.
5. During the installation process, the system prompts initialization. You can skip initialization here, because the initialization may fail. In this way, the default installation is always performed.
   You can change the server name, user name, password, port, and other information. Many tools provided by IBM need to be installed, so it takes a long time to install them.
6. Security
   After the installation is complete, you will be prompted to restart. Click OK to restart.
7. After the restart, open "Run --" And enter services. msc "to enter the service management interface. Find
   To "Informix IDS-
   Ol_user "Service, right-click to select properties when it is not enabled, and a" Startup parameter "will be displayed in the" regular "tab ", enter-Iy in it, indicating that
   Various initialization methods ). Note: many of them use "oninit" to access the ol_user instance directory on the DOS interface.
   -Iy "initialization, IBM official documentation reminds you not to use this method, this method is not successful here, it took a lot of twists and turns
8. Dbaccess is used to create databases, connect to databases, execute SQL statements, create tables, and create sessions. The specific usage is as follows:
   Next: first enter the instance (the default instance is ol_user), enter dbaccess in the DOS interface, you can see the above options, if you want to return to the parent directory, you can select "exit"
   .
9. Create a database: After Entering dbaccess, use the "up/down" key to move the focus to "create
   Database "press enter to go to the steps for creating a database
10. Run the SQL statement: the basic step is the same as step 9. After Entering, select the "new" option to write the SQL statement.
    If an error occurs in the process, use "Ctrl + X" to delete it. Press ESC to go to the upper menu and select "run" to run the prepared statement.