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

1. ???? ???? ??? ?? ????? ?? ??? ?? SQL Server ??? ??? ???????? ?? ?? Oracle ??????? ?????????? ??????? ???? ?????
2. SQL Server ??? ??? ???????? ?? ?? ??????? ??????? ????? Microsoft ???? ?? ?????? ???? Microsoft OLE DB ??????? Oracle ?? Microsoft ODBC ??????? ?? ??? Oracle ?? ???? ??? ?? ?? ????? ???? ?????-???? ??????? ?? ?????-???? ??????? Oracle ?? ?????? ???? ?? ???, ???? ?????? ?????? ???????? ?? ?????? ???? ???? ??????? ?? ??????? ?? ????? ???? ??? ????? ?? ???? ???? ???? ?????? ?? ????
3. ??? ?? ?? ????? Microsoft OLE DB ??????? Oracle ?? Microsoft ODBC ??????? ?? ??? Oracle ?? ???, ?????????? ?? ?????:
   • OLE DB ??????? ?? ODBC ??????? ?? ??? Microsoft ???? ?????? ????? (MDAC) ????? ??? ?? SQL ?? ???????? * ??? 2.3?x, ?? ??? ?? ???????? ?? Oracle 7.3 ??????? ???? ?????? ???x??????? ??????????, ?? ?????? ???????, ??????? ???????? ??? ??????? ???????? ?? SQL Server ??? ??? ???????? ???
   • ????????? ???? ?? ???? ??? MDAC 2.5 ?? ?????? ???????, SQL Server ??? ??? ???????? ?? ??????? ????? MDAC 2.1 ?? ???, ?? ???? ????? ??????? ?? ???, ?? Oracle 8 ?? ????? ???? ???? ??????? ?? ?????? ???? ?? ???? ???x?? ?????? ????????
   • MDAC 2.5, ?? ??? ?? ?????????, Oracle ?? ??? ????? ???? ?? ??? ????? ???? ?? ??? ??????? ??????????, ????????? ?????? ??????? ???????? ?? ??? ?? ?? ??? ?? SQL ????? ?? ??? ??? ??????? ????? ?????? ??? ??????? ???? ?? ?????

                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 ????? ?? ??? Oracle ??????? ?????????? ??????? ???? ?? ??? ???????? ?? ???????? ?????
5. ???????? ?? ?? ????? ????????? ?? ????? ?? ???? ???? ??? ?? ????? ???, SQL ????? ?? ??? ???

   -- 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

???:??? ?? Oracle ?? ??? Microsoft ODBC ??????? ?? ?????, ????? ?? ???? ???datasrc @???????? DSN ?? ??? ????????? ???? ?? ??? ??? ??? DSN ?? ???-??????? ??, ??????? ???????? ?????? ???? ??? ??provstr @????????? Microsoft OLE DB ??????? Oracle ?? ???, ?? ??? ??? ???????? ???? ??? ?? ?? Oracle ????? ????? ?? ????? ????TNSNames.Ora?? ??? ?????datasrc @????????? ???? ??????? ?? ??? SQL Server ???????? ?????? ??? "sp_addlinkedserver" ???? ?? ??????

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

???????????? ???, ????, ?? ????? ?? ????????? ?? ??????? ???? ?? ??? ????? ????? ??? ???? ???????, ??? ?? ????????? ?? ??? ??? ?? ??????? ???? ??? ?? ????? ???????? ??????? ?? ???? ???.. ?????, ????????? ???? ?? ?? ?? ????? ?? ??????????? ???? ???? ???.. ?????? ??????? ?? ???, ????????? ?? ??????? ???? ?? ???? ???? ??? ?? ???.. ???, ??? ??? ?????? ??????? ???? ?? ?? ?? ????????? ?? ???????????? ?? ???? ???.. ????????? ?? ??? ?? ???? ?? ???????????? ???? ?? ????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::

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

• ?????? 1:
  ?????? ????????, ????? ???? 7300 ???? ???? ?? ??? ????? ??? ??????

  DBCC Traceon(7300)

• ???? 2
  ??? SQL Profiler "????????? ?? ??????????" ????? ?????? ??? ????? ?? ?? "OLEDB ?????????" ????? ?? ?????? ????? ?????? ????? ?????? ????? ??:
  Interface::Method ????? ?????? ??? ?? ??? ???? ????
  ?? ????? ?? MDAC ?????????? ????????? ??? (SDK) ????? ?? ?? Oledberr.h ????? ??? ????? ?????? ??? ?? ???? ????

?? ??????? ?????? ????? ?? ??, ?? ?????? ????? ?? ?????? ?????? ???? ???? ?? ???? ??? ??????? ?? ??? ?? ???? ????? ???

???:??? ?? SQL Server 2005 ?? ????? ?? ??? ???, ?? ????? ?????? ????? ???? ?? ????? ?? ???? ??? ??? ??, ?????? IDs ?? ?????? ??????? ??? ?? ?? ?? ??? ??? ?????? SQL Server 2000 ??? ???? ?????, ?? ????? ???? ?????? ?????? IDs ???????

???:???????? ?????? ????????, ?? ??? ?????? SQL Server ???????? "Optimizing ?????? ????????" ???? ?? ??? ??????

• ????? 1
  ?? ?????? 7399: OLE DB ??????? '% ls' ?? ?????? ??????? ??? % ls
  ????? ???? 7300 ?? SQL Profiler ?? ????????? OLEDB ?????? ??????? ??????? ???? ?? ??? "OLEDB ?????????" ????? ?? ?????? ???? ?? ??? ????? ?????
• ????? 2a
  "ORA 12154: TNS: ???? ?? ?? ???? ?? ??? ???"
  ????? 2b
  "Oracle(tm) ??????? ?? ?????????? ??? ???? ????? ?? ??? Oracle Corporation ?? ???? ??? ?? 7.3.3 Oracle ??????? ?? ??? (?? ????) ??????? ?????????? ??????? "
  Oracle ??????????? ???????? ?? ?? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
  259959

  (http://support.microsoft.com/kb/259959/ )

  ODBC ??????? ?? OLE DB ??????? ?? ????? ???? Oracle ????? ?? ??? ??????????? ???????? ?? ???? ???? ?? ??? ???????
• ????? 3
  ?????? 7302: OLE DB ??????? 'MSDAORA' ?? ??? ?????? ???? ??? ???
  ????????? ???? ?? MSDAORA.dll ????? ??? ?? ??????? ???? ??? ??? (MSDAORA.dll ????? ?? Oracle ????? ?? ??? Microsoft OLE DB ???????.) Oracle ?? ??? Microsoft OLE DB ??????? ?? ??????? ???? ?? ??? RegSvr32.exe ?? ????? ????? ??? ??????? ???? ???? ??, ?? Microsoft ???? ?????? ????? (MDAC) ???: ???????? For more information about MDAC, visit the following Microsoft Developer Network (MSDN) Web site:
  http://msdn.microsoft.com/data/Default.aspx

  (http://msdn.microsoft.com/data/Default.aspx)
  ???:If you use a third-party Oracle provider, and your Oracle provider cannot run outside a SQL Server process, enable it to run in-process by changing the provider options. To change the provider options, use one of the following methods.
  • ?????? 1:
    Locate the following registry key. Then, change the value of theAllowInProcess(DWORD) entry to 1. This registry key is located under the corresponding provider name:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers\ProviderName
  • ???? 2
    ??? ????Allow InProcessoption directly through SQL Server Enterprise Manager when you add a new linked server. ????? ????,Provider Options, ?? ???? ??? ?? ??? ???? ?? ??? ????? ????Allow InProcess??? ?????.
• ????? 4
  Error 7303: Could not initialize data source object of OLE DB provider 'MSDAORA'. [OLE/DB provider returned message: ORA-01017: invalid username/password; logon denied] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d].
  This error message indicates that the linked server does not have correct login mapping. You can execute thesp_helplinkedsrvloginstored procedure to set the login information correctly. Also, verify that you have specified the correct parameters for the linked server configuration.
• Message 5
  ?????? 7306: OLE DB ??????? 'MSDAORA' ?? '% ls' ?????? ?? ???? ??? ???? ????????? ?????? ????? ???? ??? [????? ?? OLE/DB ???????: ?????? ????? ???? ??.][????? ?? OLE/DB ???????: ORA 00942: ?????? ?? ????? ????? ???? ??] OLE DB ?????? ????? [OLE/DB ??????? 'MSDAORA' IOpenRowset::OpenRowset ?? 0x80040e37: ????????? ?????? ????? ???? ??.]?
  ?????? 7312: ?????? ?? ????? ?????? ??/?? ?????? '% ls' OLE DB ??????? ?? ???? ??? four-part ??? ???? ??? ??, ????? ??????? ??/??? ?????? ?? ?????? ?? ????? ???? ?? ??? ?????? ???????? ???? ???????
  ?????? 7313: ?????? ?????? ?? ?????? '% ls' ??????? ?? ??? ????????? ?????
  7314 ??????: OLE DB ??????? '% ls' ??? ???? ?? '% ls' ??????
  ??? ???? ????? ?????? ????? ??????? ???? ??, ?? ???? ?????? ??? Oracle ?????? ???????? ?? ???? ?? ?? ???? ????????? ???? ??? ?? ???? ??? ???????? ???? ?? ?????? ??? ?????? ?? ????? ???? ??? ???? ??? ??? ???????? ?? ??????? ?? ?????? ?? ?????? ???? ????? Oracle ?????? ???????? ??? ??????????
  
  Oracle ???? ?? ??? ?????? ?? ????? ?????? ????? ?? ???? ???? ?? ???? ????? ??? ???????? ?? ??????? ??? ?????? ?? ????? ????? ?????? ??????? ??? ??????? ??, ?? ?????? ?? ????? ???????? ?? ?? ??? ??? ???
  
  ??? ?????? Oracle ?????? ??? ????? ?? ????? ??? ?????? ??? ?? ??? ?? ???? ?????? ?? ??? ?????? ???

  sp_tables_ex  @table_server=Ora817Link, @table_schema='your_schema_name'

  ?????? ????? 7306 ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
  240340

  (http://support.microsoft.com/kb/240340/ )

  Oracle ?? ??? ?????? ?????? SQL "??? ???? ??? ??????" ?????? ??????? ???? ??
• ????? 6
  ?????? 7413: Windows NT ???????? ????? ???? ???? ?? ??? ??????? ???????? ?????? ???? ???
  ????? 18456, ???? 14, ?????? 1, ?????? 1 ????? ?????????? ?? ??? ???? ' \ '?
  SQL ????? ???????? ?????? ?? ????? ??????? ??:
  ?? ?????? ????? ????? ???? ?? ?? ???? ?????? ?????? ?? ?????? ????? ?????? ?? ???? ???? Microsoft Windows ?????????? ????? ???? ?? ??? ????? ???? ?? ??? ??? ???? ????????-?????? ??????? ??? ???-?? ??????? ??? ???????? ??????? ???? ??, Windows NT ?????????? ??????? ?? ???????? ?? ???? ?????? ????? ???? ?? ??????? ?? ????? ?? ???? ?? ?? ?????? ??????sp_addlinkedsrvlogin.
• ????? 7
  ?????? 7354: OLE DB ??????? 'MSDAORA' ???? ??? ?????? ???????? ????? '% ls' ?? ???? ???? ?????? ??????? ???? ???
  ??? ???? ?? ?????? ????? ??????? ???? ??, ?? ???? ????? ?? ?? ?? ????? Microsoft ???????? ???? ??? ????? ???? ??? ??:
  243027

  (http://support.microsoft.com/kb/243027/ )

  FIX: Oracle ??? ???????? ????? ???? 7354 ??????
• ????? 8
  ?????? 7356: OLE DB ??????? 'MSDAORA' ???? ??? ????? ???????? ???? ????? ?? ???? ???????? ??????? ???????? ??? ????????? ?? ??? ???
  ??? ???? ???? ??? ?? ????? ?????? ?? Oracle ????? ?? ????? ???? ??, ?? ???? ????? ?????? ?? ?? ????? Microsoft ???????? ???? ??? ????? ???? ??? ??:
  251238

  (http://support.microsoft.com/kb/251238/ )

  ?????? ???????? MSDAORA ?? ??? ?????? 7356 ?? ???? ?????
• ????? 9
  ?????? 7391: ???????? ??? ???? ?? ?? ???? ??????? OLE DB ??????? 'MSDAORA' ?????? ?????? ?? ?????? ???? ????? OLE DB ?????? ????? [OLE/DB ??????? 'MSDAORA' ITransactionJoin::JoinTransaction ?? 0x8004d01b]
  ???????? ???? ?? OCI ??????? ???? ?? ???? ??? ????? ???? ??? ?? ??? ??? ??? ?? ??????? ????
  
  ???:??? ????????? ???????????? ?? ??? ??? ???, ?? MtxOCI.dll ???? ??? ??? MtxOCI.dll ???? ??? ???? ???? ??, ??? ?? ???? ?? Oracle ?? ??????? ?????? ?????? Oracle ?? ??? Microsoft OLE DB ??????? ?? ????? ?? ?? Microsoft ODBC ??????? ?? ????? ???? Oracle ?? ???? ??? ?? ???? ?????-???? ??????? ?? ????? ?? ??? ??? ?? ???? ?????? 7391 ??, ?? ???????? ???? ?? OLE DB ??????? ?? ????? ?? ??? ??? ?? ?????? ?????? ?? ?????? ????? ??? OLE DB ??????? ?????? ?????? ?? ?????? ???? ??, ?? ???????? ???? ?? Microsoft ?????? ?????? Coordinator (MSDTC) ?? ??? ???
• ????? 10
  ?????? 7392: OLE DB ??????? 'MSDAORA' ?? ??? ??? ????????? ?? ??????? ???? ?? ???? OLE DB ?????? ????? [OLE/DB ??????? 'MSDAORA' ITransactionLocal::StartTransaction ?? 0x8004d013: ISOLEVEL = 4096]?
  SQL ????? ???????? ?????? ?? ????? ??????? ??:
  OLE DB ??????? ?? ?????? 7392 ?? ??????? ?? ???? ?? ????????? ?? ???? ??? ?????? ?? ???? ?? ???? ?? ?????? ????? ???? ?? ?? ?? ???? ?????? ?? ??? ?? ???? ?? ??? ????? ?? OLE DB ??????? ?? ??????? ???? ??? ?????? ?? implicit ????????? ??????? ??, ?? OLE DB ??????? ??????? ????????? ?? ?????? ???? ????? SQL ????? ?? ?????? ?? ???????? ?? ????, ??? ?????? ?????? ?? ??? ????????? ?? ??? ???? ???? ?? ????? ???? ?????? ??? ?? ?????? ?????? ?? ???? ????
  SET XACT_ABORT ???? ??, ??? SQL Server ?????? ???? OLE DB ??????? ?? ??????? ????????? ?????? ??? ?????, ????????? SET XACT_ABORT ???? implicit ?? ?????? ????????? ??? ?????? ???????? ?? ??????? ???? ?????? ??? ????????? ???? ?? ????? ???? ?? ??? OLE DB ??????? ?? ????? ?? ??? ??? ?? ??????? ????????? ?? ?????? ???? ?????