????? ????? ???? ????? ??? ????? ?????? Oracle ?? ???? SQL ????????

?????? ????????? ?????? ?????????
???? ???????: 280106 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ??? ????? ????? ???? ????? ?? ???? ??????? ???? ????? ??????? Microsoft SQL Server ??? ????? ?????? Oracle ?????? ??????? ???????? ???????? ??????? ???????? ????? ??????? ??????? ???? ?? ?????? ??? ????? ???? ????? ??? Oracle.

??????? ?????? ???? ????? ??? Oracle

  1. ??? ???? ????? ?????? ???? ?????? ??? ??????? ???? ????? ??????? SQL Server ??? ????? ???? ?????.
  2. ????? ?????? ??????? ???? ????? ??? ??????? ???? ????? ??????? SQL Server. ????? Microsoft ??? ???? Microsoft OLE DB ?????? ??? ?????? ????? ODBC Microsoft ? Oracle ?? Oracle. ??? ??? ?????? ???? ?? ??? ?????? ?? ?????? ??? ?????? ??????? ?? Oracle ??? ???? ??????? ????? ??????? ???? ??? ????? ?? ??????? ???????? ???? ?? ?????? ??????? ?????? ???.
  3. ??? ??????? ???? Microsoft OLE DB ?????? ??? ?????? ????? ODBC Microsoft ? Oracle Oracle ? ?? ???? ???????? ?? ???:
    • ????? ?? ???? OLE DB ? ?????? ????? ODBC ???? ?? ??????? ?? Microsoft Data Access Components (MDAC) SQL * 2.3 Net. x ?? ????? ????. ??? ????? 7.3 Oracle. ?????? ?????? x ?? ????? ???? ??? ???? ????????? ??????. ????????? ?????? ?? ????????? ???? ???? ?????? SQL Server.
    • ???? ?? ?? ???? ???? MDAC 2.5 ?? ????? ???? ?????? ??? ???? ????????? ???? ???? ?????? SQL Server. ?? MDAC 2.1 ?? ?? ????? ???? ????? ??????? ?? ????? ???????? ???? ?????? Oracle 8. x ?? ????? ????.
    • ?????? MDAC 2.5 ?? ????????? ??????? ????? ?? Oracle ?????? ???? ??????? ??? ?? ??? ????? ??? ??????? ???? ???? ????? ??????? SQL Server ??? ?? ???? ?? ?????? ??????.
                 Microsoft Windows NT,
      Oracle     Microsoft Windows 95,
      Client     Windows 98, and Windows 98 SE    Microsoft Windows 2000 
      --------------------------------------------------------------------------
      
      7.x        [HKEY_LOCAL_MACHINE\SOFTWARE     [HKEY_LOCAL_MACHINE\SOFTWARE  
                 \Microsoft\TransactionServer     Microsoft\MSDTC\MTxOCI]
                 \Local Computer\My Computer]     "OracleXaLib"="xa73.dll"
                 "OracleXaLib"="xa73.dll"         "OracleSqlLib"="SQLLib18.dll"
                 "OracleSqlLib"="SQLLib18.dll"    "OracleOciLib"="ociw32.dll"
                 "OracleOciLib"="ociw32.dll"   
      
      8.0        [HKEY_LOCAL_MACHINE\SOFTWARE     [HKEY_LOCAL_MACHINE\SOFTWARE
                 \Microsoft\Transaction Server    \Microsoft\MSDTC\MTxOCI]
                 \Local Computer\My Computer]     "OracleXaLib"="xa80.dll"
                 "OracleXaLib"="xa80.dll"         "OracleSqlLib"="sqllib80.dll" 
                 "OracleSqlLib"="sqllib80.dll"    "OracleOciLib"="oci.dll"
                 "OracleOciLib"="oci.dll" 
      
      8.1        [HKEY_LOCAL_MACHINE\SOFTWARE     [HKEY_LOCAL_MACHINE\SOFTWARE
                 \Microsoft\Transaction Server    \Microsoft\MSDTC\MTxOCI]
                 \Local Computer\My Computer]     "OracleXaLib"="oraclient8.dll" 
                 "OracleXaLib"="oraclient8.dll"   "OracleSqlLib"="orasql8.dll"  
                 "OracleSqlLib"="orasql8.dll"     "OracleOciLib"="oci.dll"
                 "OracleOciLib"="oci.dll"
  4. ????? ????? ???? ????????? ???? ?????? SQL Server ??? ????? ?????? ???? ??????.
  5. On the computer that is running SQL Server, set up a linked server by using the following script.
    -- Adding linked server (from SQL Server Books Online):
    /* sp_addlinkedserver [@server =] 'server' 
        [, [@srvproduct =] 'product_name']
        [, [@provider =] 'provider_name'] 
        [, [@datasrc =] 'data_source'] 
        [, [@location =] 'location'] [, [@provstr =] 'provider_string'] 
        [, [@catalog =] 'catalog']
    */ 
    
    EXEC sp_addlinkedserver   'Ora817Link',  'Oracle',  'MSDAORA',  'oracle817'
    
    -- Adding linked server login:
    /* sp_addlinkedsrvlogin [@rmtsrvname =] 'rmtsrvname'
        [,[@useself =] 'useself']
        [,[@locallogin =] 'locallogin']
        [,[@rmtuser =] 'rmtuser']
        [,[@rmtpassword =] 'rmtpassword']
    */ 
    
    EXEC sp_addlinkedsrvlogin 'Ora817Link', 'FALSE',NULL, 'scott', 'tiger'
    
    -- Help on the linked server:
    EXEC sp_linkedservers
    EXEC sp_helpserver
    select * from sysservers
?????? ??? ??? ?????? ?????? ????? ODBC Microsoft Oracle ????? ??????? @ datasrc ?????? ??? DSN. ?????? ??? DSN - ??? ??????? ??? ????? ????? ?????? ???? @ provstr ???????. ?????? ???? Microsoft OLE DB ?? Oracle ? ??????? ????? ???????? ???? ?????? ???? ?? ??????? ?? ??? TNSNames.Ora@ datasrc ???????. ????? ?? ?????????? ???? ??????? "sp_addlinkedserver" ?? "??? SQL Server ???????".

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

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322756????? ??? ???? ???????? ? ??????? ??????? ?? Windows


????? ??????? ??? ??????? ??????? ???????? ??????? ????? ??? ??? ????? ??? ????? ??????? ????.
  • ??????? 1
    ?? "???? ???????" ????? ????????? ???????? ??????? ?????? ????? ???? 7300.
    DBCC Traceon(7300)
  • ??????? 2
    ?????? ??????? "OLEDB ?????" ??????? ?? ??? ????? "????? ? ???????" ?? ???? ????? ??????? SQL. ?? ????? ????? ????? ???????:
    ??? Interface::Method ?? ??? ????? ?? ????.
    ????? ????? ?? ??? ????? ?? ???? ?? ??? Oledberr.h ??????? ?? ?????? ????? MDAC ??????? (SDK).
??????? ?? ????? ??? ?? ????? ????? ??????? ???? ?? ???? ?? ? ?? ??????? ??? ????? ??????? ??? ?????.

?????? ??? ??? ?????? SQL Server 2005 ?? ???? ????? ????? ??? ??????? ????? ????? ??. ??? ???? ?????? ??? ????? ????? ??? ??? ????? ?? SQL Server 2000. ????? ????? ?????? ????? ?? ???? ????? ??????.

?????? ?? ????? ????? ??????? ????? ??? ???? SQL ??? ?????? ?? ??????? "?????? ????????? ???????".
  • ??????? ??????
    ??? 7399: ???? OLE DB '% ls' ?? ???. % ls
    ?? ?????? ????? ???? 7300 ?? ??????? ???? ????? ??????? SQL ??????? ????? "OLEDB ?????" ??????? ??????? ????? ??????? OLEDB.
  • ????? 2?
    "12154 ORA: TNS: ???? ?? ???? ???"
    ????? 2?
    "?????? ???? ??????? ????? Oracle(tm) ?? ??? ?????? ?????. ??? ???????? ??????? ?? ??? ???? Oracle ??? ??? ?? ??????? Oracle 7.3.3 (?? ????) ????? ?????? ?????? "
    ?????? ??? ???? ?? ????????? ??? ????? ?? ?????? ????? Oracle ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    259959?????? ?????? ????? ??????? ????? ?????? ???????? ?????? ????? ODBC "?" ???? OLE DB
  • ??????? ???????
    ??? 7302: ????? ????? ???? ???? OLE DB 'MSDAORA'
    ???? ?? ????? ????? MSDAORA.dll ???? ????. (??? MSDAORA.dll ?? ???? Microsoft OLE DB ???? Oracle.) ?????? RegSvr32.exe ????? ???? Microsoft OLE DB Oracle. ?? ???? ??? ??????? ????? ????? Microsoft Data Access Components (MDAC). ????? ?? ????????? ??? MDAC ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
    http://msdn.microsoft.com/data/Default.aspx
    ?????? ??? ??? ?????? ???? Oracle ???? ?????? ?? ???? ????? ???? Oracle ???? ????? SQL Server ????? ??????? ?? ????? ???? ?????? ?????? ????. ?????? ?????? ???? ?????? ???? ????? ???????.
    • ??????? 1
      ??? ???? ????? ??????? ??????. ??? ??? ?????? ???? ??????? AllowInProcess (DWORD) ??? 1. ???? ????? ??????? ??? ??? ??? ???? ????????:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers\ProviderName
    • ??????? 2
      ????? ???? ?????? InProcess ?????? ???? ????? SQL Server ??????? ??? ????? ???? ????? ????. ???? ??? ?????? ???? ?? ???? ??? ???? ???????? ?????? InProcess.
  • ????? 4
    ??? 7303: ????? ????? ???? ???? ???????? ?? ???? OLE DB 'MSDAORA'. [???? OLE DB/?????: 01017 ORA: ??? ????????/???? ?????? ??? ????? ";" ??? ????? ??????] [IDBInitialize::Initialize 'MSDAORA' "????" OLE DB/????? 0x80040e4d] ???? ????? OLE DB.
    ???? ????? ????? ??? ??? ?? ???? ????? ?? ????? ??? ????? ????? ?????? ???????. ????? ????? ??????? sp_helplinkedsrvlogin ????? ?????? ??????? ????? ?????? ???? ????. ?????? ???? ?? ????? ???????? ??????? ?????? ???? ?????.
  • ??????? 5
    ??? 7306: ???? ??? ?????? '% ls' ?? 'MSDAORA' ???? OLE DB. ?????? ?????? ??? ?????. [???? OLE DB/?????: ???? ??? ?????.][???? OLE DB/?????: 00942 ORA: ?? ???? ???? ?? ????? ???] ???? ????? OLE DB [IOpenRowset::OpenRowset 'MSDAORA' "????" OLE DB/????? 0x80040e37: ?????? ?????? ??? ?????.].
    ??? 7312: ??? ???? ?????? ?????? ?/?? ???????? ???? OLE DB '% ls'. ?? ????? ??? ??????? ??????? ???? ?? ???? ?????? ?????? ???????? ???????? ?????? ?/?? ????????.
    ??? 7313: ???? ??? ???? ?? ?????? ??????? ?????? ?????? '% ls'.
    err 7314: '% ls' ???? OLE DB ?? ????? ??? ???? '% ls'
    ??? ????? ????? ????? ??? ?? ???? ???? ????? ?? ???? Oracle ?? ?? ?? ???? ???? ?????? ??? ??? ??????. ???? ?? ????? ??? ?????? ???????? ?????? ???????. ??? ?? ???? ?????? ????? ?????? ? ??????? ??? ?? ???? ?? ????? ?????? Oracle.

    ??? ?????? Oracle ??? ????? ???? ?? ???? ???? ??? ?????? ???? ?????? ?????? ?????? ?? ???? ?????. ??? ?? ?????? ?? ?????? ?? ?????? ?? ?????? ?????? ??????, ??? ????? ?????? ?? ?????? ??? ??.

    ????? ???????? ??????? ?? ???? ???? ?????? ?? ???? Oracle. ??? ???? ??? ????????? ??? ?????? ??????.
    sp_tables_ex  @table_server=Ora817Link, @table_schema='your_schema_name'
    ?????? ??? ???? ?? ????????? ??? ????? ????? 7306 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    240340??????? SQL ??????? ?? Oracle ???? ??? "???? ??? ????"
  • ????? 6
    ??? 7413: ?? ?? ????? ????? ???? ?????? Windows NT ???? ???? ???????.
    msg 18456 ? 14 ??????? 1 ???? ??? ???????? ????? ?????? 1 ??? ' \ '.
    ????????? ??????? ?? "??? SQL Server ???????":
    ???? ????? ????? ??? ??? ?? ??????? ????? ??????? ?????? ???? Microsoft Windows ?????? ???? ???? ????? ???? ?????. ?? ???? ???? ??????? ?? ?? ???? ??? ????? ??????? ? ?????? Windows NT ?????? ??????? ?????? ????? ???? ??? ????? ?????? ?? ??? ????? ?????? ???? ?? ??????? ???????? sp_addlinkedsrvlogin.
  • ????? 7
    ??? 7354: ?????? OLE DB ?????? 'MSDAORA' ?? ?????? ??? ???? ??????? ?????? '% ls'. ??? ???????? ??? ?????.
    ?? ???? ???? ????? ????? ???? ?? ????? ????? ??????? ?? ????? "????? ????? Microsoft" ???????:
    243027FIX: ?????? ?????? ?? Oracle ???? ??? 7354
  • ????? 8
    ??? 7356: ?????? OLE DB ?????? 'MSDAORA' ?????? ??? ??????? ??????? ?????. ?? ????? ??????? ?????? ????? ?? ??? ???????.
    ?? ???? ?????? ??????? ???? ????? ????? ??? ???? ?? Oracle ? ?? ?????? ??????? ??????? ?? ????? "????? ????? Microsoft" ???????:
    251238??????????? ??????? ?????? ??? 7356 MSDAORA
  • ????? 9
    ??? 7391: ??????? ???? ????? ??? ???? OLE DB 'MSDAORA' ?? ????? ????????? ???????. ???? ????? OLE DB [???? OLE DB / 'MSDAORA' ????? ITransactionJoin::JoinTransaction 0x8004d01b]
    ???? ?? ?? ????????? OCI ????? ???? ???? ??? ?? ???? ?????? ?? ??? ???????.

    ?????? ?? ???? ?????? ???? ??????? ??????? ????? ??? MtxOCI.dll. ??? ?? ??? ????? ????? MtxOCI.dll ????? ????? ????????? ??????? ????? Oracle ???????? ???? Microsoft OLE DB Oracle ?? ???????? ?????? ????? ODBC Microsoft Oracle. ??? ??? ?????? ???? ?? ??? ?????? ??????? 7391 ??? ???? ?? ?? ???? OLE DB ???? ??????? ????? ????????? ???????. ??? ??? ???? ???? OLE DB ????????? ???????? ???? ?? ????? Microsoft ??????? ??????? ???? (MSDTC).
  • ????? 10
    ??? 7392: ???? ????? ?????? ????? OLE DB 'MSDAORA'. ???? ????? OLE DB [???? OLE DB/ITransactionLocal::StartTransaction 'MSDAORA' ????? 0x8004d013: ISOLEVEL = 4096].
    ????????? ??????? ?? "??? SQL Server ???????":
    ???? ???? OLE DB ??? 7392 ??? ?????? ????? ??? ???? ?? ???? ???? ????? ????? ???. ???? ??? ????? ??? ?? ????? ????? ?????? ??? ???? ?????? ????????? ?? ???? OLE DB ????? ???? ??????? ?? ?????? ????? ?? ????? ?? ????? ???? OLE DB ????????? ?????????. ????? ???? SQL ??? ????? ????, ???? ???? ????? ??? ???? ????? ??? ??????? ????? ????? ???????? ????? ?????? ????????.
    ???? SET XACT_ABORT ??? ????? SQL Server ?? ????? ??? ???????? ????????? ?? ???? OLE DB. ????? ????? SET ON XACT_ABORT ??? ????? ???????? ????? ???????? ?? ??????? ?????? ?? ?????? ????? ?? ?????. ?????? ???? ?? ???? ???? OLE DB ???? ??????? ?? ????? ????????? ?????????.

?????

????? ?? ?????????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
244661??????? ??? ?????? ????? ODBC Oracle Microsoft ? ???? OLE DB
259959?????? ?????? ????? ??????? ????? ?????? ???????? ?????? ????? ODBC "?" ???? OLE DB
239719supportability ???? ?????? ???????/OLE DB ODBC Microsoft Oracle w.r.t Oracle 8.x
193893??????? ??? ??????? Oracle ?? ?????? Microsoft Transaction Server ? + COM
191168??? ??? "-2147168246 (8004d00a)" ?????? ??? ??????? ?????? ??????
?????? ??? ???? ?? ????????? ??? ????? ??????? ???? ????? ?? DB2 ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
218590????? ????? ???????? ?? ??? ???? Microsoft OLE DB DB2
216428????? ?????? ????? ODBC Microsoft ?? DB2

???????

???? ???????: 280106 - ????? ??? ??????: 21/?? ??????/1426 - ??????: 7.7
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbhowtomaster KB280106 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????280106

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

 

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