program | network | Download First, I downloaded from the Web Application Network (http://www.webasp.net) to the five-star "Golden Disk E-government System" source program. A big company is good.
Next, how do I install, debug it. The reason for writing this document is because many of the source code downloaded on the Internet do not have enough installation and debugging instructions. The same is true for this system.
Anyway, unpack first.
Open a look, ha, a smoa.mdf, a smoa_log.ldf, and a oa20 directory. Needless to say, those two are MS SQL database files.
Next Step-by-Step describes how to run the install it.
Step One: Build database MS SQL
To create a new database, based on the file names of those two files, do the following:
1. On the General tab, enter a name: SMOA20
2. On the Data Files tab, file name and location, default to Smoa20_data, and change to SMOA20
3. "OK", database establishment
4. Stop SQL Server Service Manager
5. The download file under the root directory, smoa20.mdf,smoa20_log.ldf to MS SQL installed in the Data directory, the default installation in C:\Program Files\mssql\data, overwriting the original file.
6. Start SQL Server Service Manager and go to SQL Enterprise Manager to see if the SMOA20 data is set up:. You can look at the table or anything. Ha
Step Two: Create a new database connection user (of course, the username and password accessed in ASP)
The 29th line through the Default.asp file.
Session ("_dbconn") = "Driver={sql server};server=beyond;uid=sa;pwd=123456;database=" &database
We can see the reason for the server named beyond, username SA, password 123456
All right. I am debugging on this machine. Just change it. Change the line above to
Session ("_dbconn") = "Driver={sql server};server= (local); UID=XXXXXX;PWD=XXXXXX;DATABASE=SMOA20"
Where xxxxxx is the administrator password when you install MS SQL.
New discovery:
43 Lines, 44 lines, and a database connection.
Session ("_dbconn") = "Driver={sql server};server=" & ServerName & "Uid=" & LoginName & ";p wd=" & pas Sword & ";d atabase=jdoa20"
Application ("_dbconn") = "Driver={sql server};server=" & ServerName & "Uid=" & LoginName & ";p wd=" & Password & ";d atabase=jdoa20"
Let's change it together. To avoid mistakes, who knows what it uses, see so much code, tired. ：）
Read as follows:
Session ("_dbconn") = "Driver={sql server};server= (local); UID=XXXXXX;PWD=XXXXXX;DATABASE=SMOA20"
Application ("_dbconn") = "Driver={sql server};server= (local); UID=XXXXXX;PWD=XXXXXX;DATABASE=SMOA20"
Okay, the data connection's done.
Step Three: Register components
Such a good system, of course, can not all open source, there must be a lot of components, packaging some good stuff.
Don't worry, step by step.
Find the Oa20\dll\ directory, wow, a lot of components. Cry, register it.
The registration order is as follows:
In the Start menu---"Run", enter:
regsvr32 c:\oa20\dll\XXXXXX.dll
Of course the above directory, according to your actual decompression path.
Register all files that have the file name extension. dll in the DLL directory, count it, there are 15:
To remind, do not put on the desktop decompression, because C:\My document, such as long directory name, at the command line is not supported. The best way to headlines is to record it.
....................
Are you done with the registration, we're done, we can start next.
Fourth step: Build the virtual directory.
Right chain click OA20 Directory, "Web sharing", new share, here is also used OA20 bar. Good remember, do not love changed. ：）
Step Fifth: Perform a look
Type in IE Address: http://127.0.0.1/oa20, carriage return:)
Haha, the login page appears. The interface is also very good.
But what is this username and password?
Sixth step: To find the login username and password.
Open Default.asp, find 49 lines
sql = "SELECT * from userlist where (uid = '" & uid & "' and flag<>1 and uid<> ' Administrator ' and uid& Lt;> ' System ') or (' &uid& ' = ' Administrator ' and uid= ' Administrator ') or (' &uid& ' ' = ' system ' and UID = ' system ') '
Yes, the user table is userlist.
Enterprise Manager, open userlist to see. Ha, there are so many inside.
System administrator: Username system, password system
Super system administrator; User name administrator, password administrator
OK now, log in and try.
Step Seventh: Complete
No, that's it. Ah, you don't believe it. Copy a few column function name, show you.
Use System login Top is: User management data Dictionary role management module manage business Process form Manage instant Message logoff
Use the administrator as if more dongdong.
Something:
It's actually very simple, isn't it.
In fact, many programs do not need to explain the details, how to install, look at the structure of a program, file name. Directory name, basically know what it is doing (except for the author of course Too bad).
Especially the user name and password problem, here by the way. Many people, when there is no user name and password in the program description file, are anxious, and then ask everywhere what the username and password are, it may take a lot of time and not get the answer.
Did you try to find it on your own? It's not too late to ask if you can't find it. If you find it, you're happy.
In fact, now generally use the database, username and password is definitely in the data.
Locate the database file and load the database. If it's access, it's true that you need a password to open the data. It's okay, find conn.asp and have a look. The password is right here, why. After entering, look, general user,admin and so on is the user table, or the Administrator table. Open, ha, username and password not just come out.
Halo, the password is incredibly MD5 encryption, how to do, it does not matter, the other database in the known MD5 plus the password string, copy to this not on the line. such as admin of the MD5 encryption string is 7a57a5a743894a0e, so that all passwords are admin.
More, do not say, a lot of exploration!
For this document, there is no understanding of where, or what is wrong, please point out.
Come to my forum: http://bbs.webasp.net
Introduce a site: Web application network http://www.webasp.net (provide Web technology to Web applications, a full range of free sharing services), the source code, technical documents a lot of yo.
