????? ??????? ADO ??? ??????? ?? SQL Server ???? ???? ??? ???? ?????

?????? ????????? ?????? ?????????
???? ???????: 269882 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

??? ??????? ?????? ?????? ActiveX (ADO) ??????? ????? SQL Server 7.0 ?? SQL Server 2000 ??? ???? ????? ??? ?????? ?? ???:
  • ??? ?? ??? ????? ???? ??????? ?????? ???? ?????? 1433 (?? ????? ?????? ???? ????? SQL Server ??? TCP/IP) ? ? ??????? ??????? 1024 ??? 65535.
  • ??? ?? ???? ????? ??????? ??? ????? ???? SQL: ????? IP ?? ??? ???? DNS ?? ??? ???? ??? ????????.
  • ??? ?? ????? ??????? ??? ??? "????? ??????" ?? ??? ?????? "dbmssocn" (???? ?????? ??????) ?? TCP/IP Sockets Net-?????.
?????: ?? ???? ??? ????? ??????? ??? ???? ??????? ????? ??????; ????? ?????? ?????? ?? ????? ???? ????? ???? ???????.

??????? ????

?? ????? ????????? ???????? ?????? ? servername ??? ?? ???? ??? ???? DNS ?? ????? IP ?? ??? ???? ??? ????????:
Set Conn = CreateObject("ADODB.Connection")
Set Rs = CreateObject("ADODB.Recordset")
Set Cmd = Createobject("ADODB.Command")
	
Conn.Open "Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=username;Initial Catalog=DBNAME;Data Source=servername;Network Library=dbmssocn"
Cmd.ActiveConnection=Conn

SQL = "Select * from TABLE"

Cmd.CommandText = SQL
Set Rs = Cmd.Execute
				

?????

?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
238949????? ????? ????? ?????? SQL Server ?? ????? ????? ADO

???????

???? ???????: 269882 - ????? ??? ??????: 27/????? ??????/1425 - ??????: 4.5
????? ???
  • Microsoft ActiveX Data Objects 1.0
  • Microsoft ActiveX Data Objects 1.5
  • Microsoft ActiveX Data Objects 2.0
  • Microsoft ActiveX Data Objects 2.01
  • Microsoft ActiveX Data Objects 2.1
  • Microsoft ActiveX Data Objects 2.1 Service Pack 1
  • Microsoft ActiveX Data Objects 2.1 Service Pack 2
  • Microsoft ActiveX Data Objects 2.5
  • Microsoft ActiveX Data Objects 2.6
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbhowto KB269882 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????269882

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

 

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