HOW TO: ??????? ????? ?????? ???????? ????? ?????? ?????? ?? ???? ??????? Windows 2000

?????? ????????? ?????? ?????????
???? ???????: 313062 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ??? ????? ??????? ?????? ?????? ???????? ???? ??? ??? ????? ???? ?????? (ASP).

????? ??? ???? ????????

??????? ?????? ?????? ???????? ????? ASP ??? ????? ????? ??? ???? ???????? (DSN) ??? ???? ??? ???? ????? ???????? ???? ???? ?? ???????. ?????? ????? ?????? ???? ????? ???????.

?????? ????? ????????

?????? DSN ?????? ????? ?????? (??? Microsoft Access):
  1. ?? ?????? ?????? ??? ??????? ???? ??? ??????.
  2. ???? ??? ???? ? ???? ??? ??????? ?? ???? ??? ???? ??????.
  3. ???? ????? ??????? ??? ????? ?????? ?? ???? ????? ??????? ??? ????? ???????? (ODBC).
  4. ???? ??? ????? ??????? ???? DSN ?? ???? ??? ?????.
  5. ??? ?????? ????? ????? ???????? ???? ????? (??? ???? ??????? ?????? ????? Microsoft Access (*.mdb) ? ?? ???? ??? ?????.
  6. ?? ?????? ??? ???? ???????? ? ???? ????? ???? ???? ???????? ??? ??????? ??? ??? DSN ?? ????????? ???????? ?? ASP. ??? ???? ??????? Northwind.
  7. ?? ?????? ?????? ???? ????? ????????? DSN. ??? ???? ??????? Northwind DSN.
  8. ???? ??? ?????.
  9. ?? ???? ?????? ????? ????? ?????? ??????? ?? ??? ????? ???????? ???? ??????. ??? ???? ??????? Northwind.mdb.

    ??????: ??? ?? ??? ????? ???????? ??? ???? ??? ???? ??? ?????? ?? ???? ??? ???????. ??? ???? ???? ?????? ??????? ???? ????? ??? ????? ???????? ?? ???? ??? ?????. ???? ??? ????? ?? ?? ?????? ????? ???????? ???? ??????.
  10. ???? ??? ?????.
  11. ???? ??? ??????.
  12. ??? ??? ???? ?? ????? ?????? ?????? ????? ?????? ??? ????? ???????? ???????? ??? ??????? ??? DSN ????? ??? ??? ????? ?????? ??? ??????? ???? ??????. ???? ??? ?????.
  13. ???? ??? ????? ?? ???? ??? ?????.

?????? ??? ???? ????? ????????

?????? DSN ????? SQL:
  1. ?? ?????? ?????? ??? ??????? ???? ??? ??????.
  2. ???? ??? ???? ? ???? ??? ??????? ?? ???? ??? ???? ??????.
  3. ???? ????? ??????? ??? ????? ?????? ?? ???? ????? ??????? ??? ????? ???????? (ODBC).
  4. ???? ??? ????? ??????? ???? DSN ?? ???? ??? ?????.
  5. ??? ???? SQL ?? ???? ??? ?????.
  6. ?? ?????? ????? ? ???? ????? ???? ???? ???????? ??? ??????? ??? ??? DSN ?? ????????? ???????? ?? ASP. ??? ???? ??????? Northwind.
  7. ?? ?????? ?????? ???? ????? ????????? DSN.
  8. ?? ??????? ???? ???? ??? ????????? ???????:
    • ??? ??? SQL Server ??? ???? ???????.
    • ??? (??????) ?? ???? ????? SQL Server ???? ?????? ??? ??????? ???? ???.
    • ???? ????? (????????) ?????? ???? ?? ???? ?? ??????? ??????.
  9. ???? ??? ??????.
  10. ??? ??? ??? ?? SQL Server ?????? ?? ??????? ???? ????? ??????, ???? ??? ????? ???????? ???? ?????. ??? ???? ??????? ?????? ?? Windows NT ???????? ???? ????? ?????? ???? ???????. ???? ??? ??????.
  11. ???? ?????? ???? ???????? ????? ????? ???????? ?????????? ??? ? ??? ????? ???????? ???? ?????? ?? ??????? (??? ???? ??????? Northwind) ? ?? ???? ??? ??????.
  12. ???? ??? ????? ? ???? ??? ????? ?? ???? ??? ?????.

????? ?????? ASP ??? ??????? ?????? ?????? ???????? DSN

?? ???????? ????? ????? ASP ????? ????? ?????? ?????? ???????? ???? Access ????? ?????? ?????? ActiveX (ADO) (DAC):
  • ??????? ???? ????? ADO ??? ????? ????? ????? ????????.
  • ??????? ???? Recordset ??????? ?????? ???? ????? ????? ?????? ??????.

??????

???? ?????? ?????? ????? ??????? ????? ????? ?????? Microsoft Access NorthWind ???????? ?????? ??? ASP.

??????: ????? ??? ?????? ?? ??????? ????????? ????? ??????? Windows 2000 ??? ???? ??????? C ???????? ??? ??????? ????????? ?? Microsoft Access ?? ????? NorthWind ????? ????????.

???? 1: ????? DSN

???? ??????? ???????? ?? ?????? For a Database Program ??? ??????? ?????? DSN ??? ????? ????? ?????? Microsoft Access Northwind.mdb.

??????: ?????????? Northwind.mdb ????? ??????? ?? C:\Program ?????? Office\Office\Samples Files\Microsoft.

?????? 2: ????? ???? ASP

  1. ??? ????? "???????".
  2. ?? "???????" ? ???? ???????? ???????? ???????:
    <HTML>
    <HEAD><TITLE>ASP Database Connection</TITLE></HEAD>
    <BODY BGCOLOR=white>
    <H1>Northwind Database Contacts</H1>
    <%
    Dim Connect, selectSQL, RecSet 
    Set Connect = CreateObject ("ADODB.Connection")
    Connect.Open "DSN=Northwind" 
    selectSQL = "SELECT * FROM Customers" 
    Set RecSet = Connect.Execute (selectSQL)
    If NOT RecSet.EOF
    THEN
    DO UNTIL RecSet.EOF
    Response.Write RecSet("Companyname") & ", " & RecSet("Contactname") & "<BR><BR>"
    RecSet.MoveNext
    Loop
    End If
    RecSet.Close
    Connect.Close
    Set RecSet = Nothing
    Set Connect = Nothing
    %>
    </BODY></HTML>
    					
  3. ?? ??????? ???? ???? ??? ??? ????.
  4. ?? ???? ?????? ??? ???? ? ????? ??? C:\Inetpub\wwwroot ?? ??????? ??? ?? ??? ???? ??????? ?? ??????? ??? ???? ? ???? database.asp ?? ?????? ??? ????? ?? ???? ??? ???.
  5. ?? ?????? "???????".

?????? 3: ?????? ???? ASP

  1. ???? ??? ???? ?? ???? ??? ?????.
  2. ?? ?????? ???? ???? http://localhost/database.asp ??? ?? ???? ??? ?????. ??? ??? ???? ??? ???? ????? ??????? NorthWind ????? ?????? ????? ?? ???? ????????.

??????? ??????? ????????

??? ????? ????? ?? ??????? ?????? ?????? ???????? ????? ??? ASP ???? ?? ???? ???????? ??????? ?????? ??? ????? ????????:
  • ???? ?? ?? DSN ?????? ???? ?? ?????? ????? ?????? ??? ????? ????????.
  • ??? ????? ??????? ????? SQL ??? ????? ???? ?? ??????? ???? ???? ????? IIS ?????.
  • ??? ????? ??????? ?????? ?????? Microsoft Access ?????? ?? ?? ???? IIS ???? ?????? ??????? ??? ?????? ??? ?? ????? ????? ????????. ??? ?????? ????? ??? ???? ??? ???? ?????????? ??? ????? ????????.

?????

?????? ??? ??????? ?????? ??? ????? ????? ?? ????? ASP ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
308164HOW TO: ????? ??????? ??? ASP ????????
165492HOWTO: ??????? ADO ?? ????? Foxpro ?????
?????? ??? ??????? ?????? ??? SQL Server ???? ???? Microsoft ?????? ??? ?????:
http://www.microsoft.com/SQL
?????? ??? ??????? ?????? ??? Microsoft ??????? ?????? ??? ????? Microsoft ??????? ??? ?????:
http://msdn.microsoft.com/en-us/library/ms950396.aspx
http://msdn.microsoft.com/en-us/default.aspx
?????? ??? ??????? ?????? ??? ODBC ???? ???? Microsoft ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/ms710252(VS.85).aspx

???????

???? ???????: 313062 - ????? ??? ??????: 10/????/1427 - ??????: 7.3
????? ???
  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Advanced Server
  • Microsoft Windows 2000 Professional Edition
  • Microsoft Small Business Server 2000 Standard Edition
  • Microsoft Internet Information Services 5.0
????? ??????: 
kbmt kbenv kbhowto kbhowtomaster KB313062 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????313062

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com