How to install and debug the source program downloaded from the network: an example analysis of the Golden Disc e-Government system

Source: Internet
Author: User
First of all, 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 Filesmssqldata, 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=" & PA ssWOrd & ";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. :)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.