????? ????? ????? ????? ?????? ?? ???? ASP ?? IIS

?????? ????????? ?????? ?????????
???? ???????: 300382 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ???? ??? ??? ??????? ?????? ??????. ???? ??? ??????? ???? ????? ????? ????? ????? ?????? ?????? ?? ????? ???????? ???????? ????? ????????.

???????

???? ??? ??????? ??????? ?????? ??????:
  • ????? ????? ?????? ?????? (ASP) ??? ???? ??? ??????? 5.0 ?????? ??????? ?????? (IIS) ?? Microsoft Data Access Components (MDAC) ??????? 2.5 ?? 2.6 (?? ???? ????? ?????? Jet)
  • ??????? ?????? ?????? ????? ?? ?????
  • ????? ASP ??????? 5.0 ?? ???? ?? Microsoft Internet Explorer

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

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

Microsoft Access

???? DSN
<%
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydatabase.mdb"
%>
				
OLE DB
<%
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:\mydatabase.mdb"
%>
				
??? DSN
<% Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "FILEDSN=ADSN"
%>
				
?? DSN ????? ?? ?????? ????/??????
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>
				
?? DSN "?" ???? ????????/????
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname","username","password"
%>
				
???? DSN ? ???????? ???? ???? ?????
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=c:\mydatabase.mdb" 
Conn.Open DSNtest
%>
				
???? DSN ? ???????? Server.MapPath

??????: Server.MapPath ?? ?????? ?? ??? ???? ???. ???? ???????? ???? C:\Inetpub\Wwwroot.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/databases/mydatabase.mdb")
Conn.Open DSNtest
%>
				

Microsoft SQL Server

OLE DB
<%
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=mydatabase "
%>
				
?? DSN
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=mydatabase"
%>
				
???? DSN
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=mydatabase"
Conn.open DSNtest
%>
				

Microsoft Visual FoxPro

???? DSN
<%
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\databases\mydatabase.dbc"
Conn.Open ConnStr
%>
				

Oracle

ODBC ?? DSN
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.cursorlocation=adUseClient   
' requires use of adovbs.inc; numeric value is 3
Conn.open "DSN=test;UID=name;PWD=pass"
%>
				
OLE DB
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.cursorlocation=adUseClient   
' requires use of adovbs.inc; numeric value is 3
DSNTest="Provider=MSDAORA.1;Password=pass;User ID=name;Data Source=data.world"
Conn.open DSNtest
%>
				



?????

?????? ??? ???? ?? ????????? ??? ????? ???????? ?? ??????? ?????? ?? ?????? MDAC ???? ???? Microsoft ?????? ??? ?????:
http://msdn.microsoft.com/en-us/data/aa937729.aspx






???????

???? ???????: 300382 - ????? ??? ??????: 30/????/1427 - ??????: 4.4
????? ???
  • Microsoft Internet Information Services 5.0, ????? ?????? ??:
    • the operating system: Microsoft Windows 2000
????? ??????: 
kbmt kbhowto kbhowtomaster KB300382 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????300382

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

 

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