about Linked Servers

From: Windboy (jeoungsu@msn.com)
Date: 05/28/02 

From: "Windboy" <jeoungsu@msn.com>
Date: Mon, 27 May 2002 22:58:55 -0700

Hi~~

We have SQL 7.0 (SP4), MDAC 2.6 And Oracle 8i

I want Oracel To SQL Server Access.

SQL 7.0->Linked Servers->New Linked (Name->MESORA)
complete!!

ME Tree -> MESORA->Tables Click -> Right Area -> oracel
tables display !!

But.. Query Analyzer Not Complete.. 

--
SELECT * FROM MESORA..MES.TB_STD_EMP
----
OLE DB provider 'MSDAORA' reported an error. The provider 
did not give any information about the error.
why Job failed ??
PS : Try.. Install My pc -> SQL 2000 and they job 
complete!!
help meeeeeee

Relevant Pages

  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
  • adsi linked servers
    ... I'm following the directions for the OLE DB Directory ... I add the linked server with this TSQL ... from OLE DB provider 'ADSDSOObject'". ... If I execute an openquery command from query analyzer I ...
    (microsoft.public.sqlserver.security)
  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)
  • RE: Samplclnt example in MDAC 2.8: My Story
    ... | OLE DB provider/consumer sample that is included in the MDAC 2.8 SDK. ... | what the consumer client uses to read the rudimentary .csv data file. ... | compiler errors. ... | sample OLE DB provider. ...
    (microsoft.public.data.oledb)
  • OLE DB error trace (OLE/DB Provider MSDAORA)
    ... OLE DB provider 'MSDAORA' ... Provider 'MSDAORA' IDBInitialize. ... I received the OLE/DB ...
    (microsoft.public.sqlserver.clustering)