???? ????? ??? ??? ????? ?????? ??????? ?? ???? OLE DB ?? SQL Server: "???? ????? ?????? ????? OLE DB"

?????? ????????? ?????? ?????????
???? ???????: 306649 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

?? ????? ???? Microsoft OLE DB ?? SQL Server ????????? ????????? ?? ??? ????? ????? ????? ???????:
???? ??? ????? ?????? ????? OLE DB '% ls'.
Microsoft SQL Server ?????? ????? ????? ??????? ????? ??? ??? ?????? ???? ??? ?? SQL Server:
????: ????? 7392, 16, ????? ?????? 2?
???? ??? ????? ?????? ????? OLE DB 'SQLOLEDB'. [???? OLE DB/?????: ?????? ????? ??? ???? ?? ???? ???? ?? ???? ????? ???.]

?????

???? ??? ????? ??? ?? ????? ????? ?????? ??? ???? ?????? ????????? ?? ???? OLE DB ????? ???? ??????? ?? ?????? ????? ?? ????? ?? ????? ???? OLE DB ????????? ?????????. ????? ???? SQL ??? ????? ????, ???? ???? ????? ??? ???? ????? ??? ??????? ????? ????? ???????? ????? ?????? ????????.

????

??????? ?????? ??? ??? ??????? ?? ?????? XACT_ABORT ??? ON ??? ????????. ???? ??? SQL Server ?????? ???????? ??????? ??? ???? ??? ????? ?????? ????? ????? ????????. ???? SET XACT_ABORT ??? ????? SQL Server ?? ????? ??? ???????? ????????? ?? ???? OLE DB.

?????

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

??????? ????

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

?????? ??? ??????? ???? ????? ?????? ???? OLE DB ?? SQL Server ???? ????? XACT_ABORT.
  1. ??????? ???? OLE DB ?? SQL Server ?????? ???? ????? ???? Sales ?????? ???? Microsoft OLE DB ?? SQL Server.
    USE Master
    GO
    EXEC sp_addlinkedserver 
        'Sales',
        N'SQL Server'
    GO
    					
  2. ???? "????????? ????" ?? ?? ?????? ????? ??????.
    Begin Transaction
    Insert into Sales.Northwind.DBO.Customers(CustomerId,CompanyName) Values ('1000','Test')
    Commit Transaction
    					
    ??? ???? ????? ????? above-mentioned.

    ???? ??????

  3. ?? ?????? ????? ?????? ??? ????? XACT_ABORT ??? ON:
    Set XACT_ABORT ON
    					
  4. ????? ??????? ????? ??? ????. ???? ??? ?? ????? ???????? ?? ?????? ???? ???.

?????

?????? ??? ??????? ??????? ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
177138INFO: ??????? ?????? ??? ????? ?? ODBC/OLE DB/ADO
187289HOWTO: ???? ??????? ?????? ?? Oracle

???????

???? ???????: 306649 - ????? ??? ??????: 07/?? ??????/1426 - ??????: 4.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.6 Service Pack 1
????? ??????: 
kbmt kbprb KB306649 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????306649

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

 

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