I'll do a tutorial on setting up the server of o2jam, I hope it will be helpful to novices.
I believe you have all the database files, but in fact you only need three of them to do it. Test2...o2jamtrade---onlinereport is GO.
First make sure you have MSSQL installed. If not... then install it first...
Enterprise version installation
Find the MSDE directory in the installation disk of the SQL server, and click to install it, and then go straight to the next step
Install the client tool directly (click directly under the root directory of the CD)
Enter regedit in run to open the registry editor and find [HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER].
There is a key value LoginMode in the item. By default, the value is 1. Now change the value to 2 and restart the computer.
Install MSSQL...then we start our journey:
First open the Enterprise Manager-----create a new database (the name is the library you restored test2...o2jamtrade---onlinereport)
Restore the database -----
Pour in from the device-----
Select the library you need to pour in.-----There is a problem here. Some people's database is not installed by default, so here you need to modify it to you
The directory you want to install...C:\Program Files\Microsoft SQL Server\MSSQL\data is modified to what you need.
I installed it by default
Choose Force Restore... Actually, it doesn't matter if you don't choose
The other two are restored in this way
The database restore has been completed. Now let’s modify the database
test2 database
T_o2jam_gatewayaddr table......right click
Just close it directly
Modify the T_o2jam_planetInfo table right-click-design table... Because there is an IP length problem here... so change the numerical length
varchar is the longest
Close, choose Yes
It is said that this table can be done without changing... I haven't tried it... Haha! Now we change the password of SA:
Security-Login-123...You can also decide on your own... Just don't be attacked
Now the database is completed...we do the ODBC data source:
Open Control Panel Management Tools Data Source (ODBC) System DSN
Choose the last SQL SERVER, the name is your database name
If the pull-down does not have (local)... Then write it yourself... There must be ()...
Select and use support
SA and your password
Select the corresponding database
OK...the data source is OK. Let's set up the server:
The right-click attribute under DATA... Go to read-only... I found that it could not be modified before... It turns out that this is a mistake
I thought it was because of the different formats... I changed it with UE... The technology is weak... I can't do it
DNS = test2
UID = sa
PWD = 123 -----------------I don't need to say anything here
save
-------PORT = 15030 This change 15030 I have modified it
172.28.136.198IP uses your public or intranet IP. Do not use 127.0.0.1
DSN = test2
UID = sa
PWD = o2jamtest---Your password
config_gm.ini-----------------------------------------------------------------------------------------------------------------------
config_gw.ini----- PORT = 15017---changed 15010
Don't use 127.0.0.1 for all IPs... Why? I don't know... I'll test it, and it will report an error.
OK... All servers are set up... Turn on the server...
order
Let's go in and take a look... Well, the login patch is provided...specific...
The login... can be modified. You can also use this batch processing 1 172.26.45.237 o2jam/patch 172.26.45.237:15000 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1.26.45.237 15010 172.26.45.237 15010 172.26.45.237 15010 172.26.45.237 15010 172.26.45.237 15010
OK...Let's go in
Let's enter. Haha...it's time to fight...GO...
Well, don't ask me why the web page cannot be displayed there... It's you that...
OK... Then set the registration page...you need IIS...I won't talk about it in detail. Just make a modification
I've posted the registration page. Go down by myself
"DRIVER={SQL Server};SERVER=172.28.136.198; database=test2;UID=sa;PWD=123;"No need to say anything else...Okay...I won't say anything else...I'm done
Username and password are written in member
What clothes are in this table BAG1 BAG2..........
It's your package space
Haha...Okay...I've studied the others myself...........................