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

???? ?????? ???? ??????
???? ID: 300382
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

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

??????????

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

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

?? ???????? ?? ???? ???????? ?????????? ?? ??? ???? ?? ??? ???? 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 ?? ??? ?? ?????????? ID/??????? ?? ???
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>
				
DSN ?? ?????????? ID/??????? ?? ???
<%
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

DSN ?? ??? ODBC
<%
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






???

???? ID: 300382 - ????? ???????: 04 ?????? 2010 - ??????: 2.0
??????: 
kbhowto kbhowtomaster kbmt KB300382 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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