Kunming City Commercial Bank Hundred Bank Microcope
This article assumes that the Informix uses from zero, which will be described from zero to maximize the various detailed steps of INFORMIX.
In this paper, the contents of VI editing are placed between two lines, you have to edit the rear storage.
One: Download Informix-Online Database Server Linux Trial System
Address: http://www.intraware.com, registration becomes the user of the Informix trial system, tell the correct email address, then Intraware will send you an email, tell you the installation authorization name of the station system downloaded later and password. Of course, when you download, the authorized user name and password will also appear on the screen, you have to copy it. (The general authorization name and your name are different)
After the registration is successful, enter the EVLAUTE (or Evaluation or Trial Download) Link page, login in enters the download page, select the Informix product you want. Since this article uses Linux as an example, download INFORMIX DYNAMIC_SERVER_2000, INFORMIX_DYNAMIC_SERVER_2000_S_O_V9_21_UC2_FOR_LINUX.ZIP.
2: Prepare Informix-Online 2000 /,
Unzip download file informix_dynamic_server_2000_s_o_v9_21_uc2_for_linux.zip (regardless of WIN Download or Linux Download)
In Linux, register with root into the system
1: Establish Informix User Name (AddUser)
2: Establish an Informix group (GroupAdd)
3: Change the properties of the INFORMIX user main directory
# Chown Informix.informix / Home / Informix
If you are done with WIN:
1: If you don't have to install Linux to start on the same machine, hang in the hard disk partition where the download file is located, as I D:
# MKDIR / MNT / WIN
# Mount -t vfat / dev / hda5 / mnt / win
2: If Linux is installed on another machine, only set Samba shares, copy the INFORMIX Online 2000 system downloaded under WIN to the lower directory of the Linux machine (this example / mnt / win)
3: If you are downloaded with Linux, use the stored directory. (This example is still / mnt / win).
Three: Start installation
Enter the downloaded Informix Online directory
# CD / MNT / WIN
Set the installation environment
# Informixdir = / home / informix
# Export informixdir
Since InterWare downloaded Informix Online 921 installation package RPM directory structure is / opt / informix or / usr / informix, it is not necessarily / home / informix, the installation command is as follows:
# rpm -ivh -relocate / opt / informix = / home / informix informix_dynamic_server_2000_s_o_v9_21_uc2_for_linux.rpm
You will ask you to enter your license number and password during the installation process.
It is recommended that you do not install this package in the GUI environment, which may be unsuccessful installed.
Four: Start setting up a Linux work environment
# CD / ETC
# Vi Hosts
============================================================================================================================================================================================================= =================== Add your network card address, Host host name, and other computer addresses to access this machine according to the actual situation
============================================================================================================================================================================================================= =========================
# Vi Services
============================================================================================================================================================================================================= =========================
SQLEXEC 9999 / TCP # Fun your Informix database server service service is SQLEXEC
============================================================================================================================================================================================================= =========================
# CD / root (Set the root user boot environment)
# Ls -a
# Vi .bash_profile
============================================================================================================================================================================================================= ======================= Path = $ PATH: $ homen / bin: $ home / etc: / home / informix / bin: / home / informix / ETC
.......
Informixdir = / home / informix
Informixsqlhosts = / home / informix / etc / sqlhosts
InformixServer = DEMO_ON #Online server name, and the service name is not a concept
Term = 100 # Menu INFORMIX DBACCESS
EXPORT path. . . . . . . . Informixdir InformixServer Informixsqlhosts Term
============================================================================================================================================================================================================= =========================
Set the Informix user environment
# Cd / home / informix
# Ls -a
# Vi .bash_profile
============================================================================================================================================================================================================= =========================
PATH = $ PATH: $ HOME / BIN: $ HOME / ETC
.......
Informixdir = $ HOME
Informixsqlhosts = $ home / etc / sqlhosts
InformixServer = DEMO_ON #Online server name, and the service name is not a concept
Term = 100 # Menu EXPORT path for INFORMIX DBACCESS. . . . . . . . Informixdir InformixServer Informixsqlhosts Term
============================================================================================================================================================================================================= =========================
Establish an Online Service Library Server Data Space File (Suppose you plan to build in / home / informix, otherwise please enter the directory such as / home / informix), just take a name, ROOT_CHUNK
# CD / Home / Informix (Data Space Directory)
# Cat / dev / null> root_chunk
# Chmod 660 root_chunk
Set other properties
# Cd / home / informix
# CD ETC
# Cp sqlhosts.std sqlhosts
# Vi sqlhosts
============================================================================================================================================================================================================= ==========================
# 地图: Online Server Name Protocol Name HOST Host Name Service Service Name
Demo_on onsoctcp myhostname sqlexec
============================================================================================================================================================================================================= ==========================
# Cp onconfig.std onconfig
# Vi onconfig
============================================================================================================================================================================================================= ========================== # Change all such as / opt / informix to / home / informix
..............
Rootpath / Home / Informix / root_chunk
..................
Rootsize 40000 (according to you need to set the required data space size, kiloby, such as 40 trillion)
..................
DBSERVERNAME DEMO_ON (same as SQLHOSTS)
============================================================================================================================================================================================================= ==========================
OK, set it, Ctrl D exits Logout, and use root to enter login.
Start Informix Online
When started for the first time, INFORMIX ONLINE is initialized.
# OnNInit -i (lowercase, only the parameters for the first time), what is Yes, etc. Half minute
# Ps -ef can see the Online server has already started.
# OnMode -k Turn the online server,
# OnNit Re-press the normal method to boot the ONLINE server, no parameters are required.
Congratulations, your Informix Online has ran well.
5: How to set ODBC in WIN to access Informix Online
First download the Informix Connect for Win, an Informix ODBC driver, or a Client package. I am a copy of others, I can consult someone else or find it. If you don't have slowed, you can go to http://winhelp.163.net/win_nt95-informix-odbc.zip to see, pay attention to case. Install it on the WIN machine, for example the directory is C: / Informix
Set
1: Run Informix Setnet32
Setting in Enviroment:
InformixDir = C: / Inform iDBC / Connect Directory
InformixServer = DEMO_ON (ONLINE Database Server Name)
InformixSqlhosts = / home / informix / etc / sqlhosts (same as the location of Sqlhosts on Linux) Set:
Informix Server = DEMO_ON (ONLINE Database Server Name)
Host Name = MyHostName (HOST host name) of Linux
Protocol name = onsoctcp
Service name = SQLEXEC (service name)
Set in Host Informix:
Current host = myhostname (HOST host name) of Linux
User name = Informix (username in Linux, you can fill in it, you must fill in)
Password option = password
Password = Move the cursor to this edit frame, just fill in more than six or more letters
2: Sets the / etc / service file on the Linux machine on the WIN machine
On the WIN machine, the Services file is located in the WIN directory of your Win machine, such as C: / Win98
In the DOS environment,
C: / Win98> Edit Services
============================================================================================================================================================================================================= =====================
# Add to the following line
SQLEXEC 9999 / TCP
============================================================================================================================================================================================================= =====================
3: Start setting Informix ODBC
Informix ODBC or Connect or Client generally provides two drivers, one can be used for INFORMIX 9 (INTERSOLVE 3.10 32-bit Informix 9), and another can be used for previous versions (INFORMIX 2.80 32 bit).
Enter the control panel, open the ODBC setting box
(1) Setting up the 9th edition ODBC driver
Add a data source, select the driver to INTERSOLVE 3.10 32-Bit Informix 9,
Define the data source name, such as: Informix9,
Define the Data Source Description Data Source Description as any, define the specific database names you want to access, such as MyDBS (ie, the database name you created under Linux),
The default username Default user name is Informix (the username on Linux, you can fill any first),
Define hostname host name for myhostname (machine name in your Linux database server)
Define Database Service Name Service Name to Demo_on (set in Sqlhosts in Your Linux)
Protocol setting protocol type is Onsocpp
(2) Setting up the previous version of ODBC settings
Add a data source, select the driver for Informix 2.80 32-bit
Define Data Source Names such as: Informix7,
Define Data Source Description Data Source Description is arbitrary,
Define the specific database names to be accessed, such as MyDBS (that is, the database name you created under Linux),
The default username Default user name is Informix (the username on Linux, you can fill any first),
Define hostname host name for myhostname (machine name in your Linux database server)
Define Database Service Name Service Name to Demo_on (set in Sqlhosts in Your Linux)
Protocol setting protocol type is Onsocpp
OK, you can now try other programs that support ODBC to view database content, such as SQLEXPLORER in Delphi / CBuilder, pop up the Registration dialog box when open, you must enter the right user with the correct access informix online database permissions on your Linux. Name and password, you can see the table, content, process, etc. of your database MYDBS on WIN.
Do you have any good suggestions, welcome everyone to mention.
In addition, the author has a problem, I don't know if the bit can answer:
I downloaded Informix SE 7 from InterWare. XX version, I don't know if it supports Win9x ODBC access, how to set it. I don't know how to start the INFORMIX SE database background service, just use OnNIT to start service like Online? ? ?
Please pay attention: New version of the network to make money cheating programs are coming soon, after opening the billboard, don't have a browser to open, whether you are using Delphi programming or use Word typing, or some other applications on the screen, or some other applications on the screen Regardless of any applications, all the systems can be automatically simulated as browser environments, and any status can work! ! ! !
The new generation supports full Chinese PDF format anti-compile to TXT program is coming soon (supporting CJK Sino-Japanese Harborghum Harbor ") is testing, so stay tuned.