DB2 Client installation + SysBase installation tutorial + SysBase Client installation tutorial

DB2 Client installation + SysBase installation tutorial + SysBase Client installation tutorial

1. Install the DB2 client:The installation is basically "Next --" Next -- "Next", which is very simple and difficult.

After obtaining the resource, decompress the DB2 file and get the following: SqlDbx.exe is the installation directory under the ADMCL directory. After the installation is complete, the desktop will generate the same login icon.

Enter the ADMCL directory to obtain the following information:

Then, run setup.exe -- Next to install successfully.

DB2 client Configuration:

The ultimate goal is to connect to the remote server database through the client: Now you need to configure: start -- all programs are configured

Set in the setting tool:

Right-click the database, and I have configured a database instance as follows:

The overview file is used by default. Here, select: manually configure the database connection.

Next -- select TCP/IP

Next, enter the following configurations:

Now the client is configured successfully: log on to the server

After the client is successfully installed, the logon icon shortcut is displayed on the desktop.

Log on to your account.

Install SyBase:[I only write my experiences based on my own ideas and opinions. I am sure there is something wrong with my online materials. I hope you will forgive me]

1. There are a lot of installation tutorials on the Internet. After my own continuous attempts, the installation will continue all the way to Next. [Very simple]

2. some people say that I want to install the client, but the information provides or says that the installation package provided by the leader has more than seven hundred MB, I think we have installed a set of servers and clients. to connect to a remote server, you must install a local server. The Sybase version of SyBase 12.5.1 actually contains the client. This tool is very powerful.

3. Some people say that I want to install the client, but not the server. In fact, I can also: Here I will give you a client, which is about 5 MB in size. However, only SQL commands are supported and the display is not beautiful.

The final installation result is as follows: SQL Advantage is the command line form for installation.

I encountered the following three problems during the installation process, and there was very little information on the Internet. I summarized the solution myself:

1. Service Name: SYBBCK_WFC320140901OH_BS

SYBMON_WFC320140901OH_MS

SYBSQL_WFC320140901OH

The name of SYBXPS_WFC320140901OH_XP is incorrect. It indicates that the Service name must start with a letter, but cannot be changed. In this case, you can only change the computer name from the solution: Installation prompt. For example, if my computer name is 2013320140901OH, I change it to WFC320140901OH.

2. */data/*/master. dat file already exists. We recommend that you delete, change the installation directory, and reinstall it. The program is being installed, and the file is being used and cannot be deleted.

Solution: Change the installation directory. [No further reason]

3. You will find that the Base in S month cannot be fully detached, especially in the uninstall program, the program is always undetachable. The Internet says how to completely uninstall, stop the service, and delete the registration code.

My suggestion: After the installation fails, I did not delete anything and directly re-installed it. [Of course, the installation is successful after the preceding two bugs are solved. We recommend that you delete the Registry file, clear the installation directory, and reinstall the registry after the installation fails]

After the installation is complete, you can log on:

 

Tool ----- connection: enter relevant parameters.