Linux + Informix Backstage Database System "====" WinxxODBCDELPHICBUILDERVB programming settings

zhaozj2021-02-08  230

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.

转载请注明原文地址:https://www.9cbs.com/read-2591.html

New Post(0)