PRB: "??????? ???????" SQL ?? ????? Oracle "???? ??? ????" ???

?????? ????????? ?????? ?????????
???? ???????: 240340 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

???????

?????? ??????? ??????? ?? ???? ??? Oracle ????? ???????? ???? MSDAORA OLE DB ??? ???? ??????:
select * from OracleServer..demo.Product
				
?? ????? ??? ?????? ??? ???:
????: ????? 7306 ? ????? 16 ???? 2? ??? 1
???? ??? ?????? ' "????? ????????". "??????"' ?? 'MSDAORA' ???? OLE DB. ?????? ?????? ??? ?????.
[???? OLE DB/?????: ?????? ?????? ??? ?????]
[???? OLE DB/?????: 00942 ORA: ?? ???? ???? ?? ????? ???]

?????

????????? ?? ?? ???? ???? ???? ???? ?????? ?? Oracle ??? ?? ?????? ???? SQL ??????? ??? ?????? ???????? ????? ??? ??? ??????????? ??? ????.

???? ??????

??????? ??????? ??????? ??? ??????? ??? ??????? ?? ???? Oracle ?????:
  • ??? ?? ????? ?????? ?????? ??????? ?? Oracle ??? ?????? ?????? ? ??????? ???? ????? ?????? ???????. ??? ???? ??????? ??? ?? ???? ??????? ?????:
    select * from OracleServer..DEMO.PRODUCT
    						
  • ??? ?? ????? ?????? ?????? ??????? ?? Oracle ?? ?????? ?????? ? ?????? ??? ???? ???? ???? ????? ??? ?? ????????? ????? ?? ????? ??????? ?? Oracle.
?? ??? case-sensitivity ????? ??? ??????? ???? ?????OpenQuery ?? OpenRowset. ??? ?? ???? ??????? ?????:
SELECT * FROM OPENQUERY(OracleServer, 'select * from PrOdUct')
go
SELECT * FROM OPENRowset('MSDAORA', 'myOracleServer';'demo';'demo', 'select * from PrOdUct' )
go
				

??????? ????

???? Microsoft SQL Server ??????? 7.0 ?????? ??? ????? ????????? ????? ?????? OLE DB. ???? ????? ??? ???????? ??????? ?????OpenQuery ?? OpenRowset Transact-SQL ?? ???????? ??????? ?????? ??? ????? ??? ?? ??? ??? ???? ?????. ??? ???? ??????:
sp_addlinkedserver 'mylinkedserver', 'product_name', 'myoledbprovider', 'data_source','location', 'provider_string', 'catalog'
SELECT * FROM OPENQUERY(mylinkedserver, 'select * from table1')
				

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

  1. ????? ???? ????? ????? Oracle:
    EXEC sp_addlinkedserver   'OracleServer',  'Oracle',  'MSDAORA',  'myOracleServer'
    go
    EXEC sp_addlinkedsrvlogin 'OracleServer', 'FALSE', NULL, 'demo', 'demo'
    go
    						
  2. ????? ??????? ??? ??? ?????:
    SELECT * FROM OracleServer..demo.Product
    						
    ???? ?????? ????? ??????? ?? ????? "?????? ?????.

?????

?????? ??? ??????? ?????? ??? SQL Server ????????? ??????? ?? ???? ?????? Oracle ? ???? ??????? SQL 7.0 ???????? "OLE DB ?????? ?? Oracle" ???????? ??????? ?? "????? ????? Microsoft:
220915PRB: ??????? SQL ??????? ?? Oracle ???????? ???? ??????

221552PRB: SQL ??????? ????????? ?? ??? ????? ???? NUMERIC Oracle

???????

???? ???????: 240340 - ????? ??? ??????: 21/???? ??????/1435 - ??????: 4.2
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbdatabase kboracle kbprb KB240340 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????240340

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

 

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