Re: Query Oracle database without linked server

You should post the error. That might help someone recognize the problem. -
RLF

<YuS.Mei@xxxxxxxxx> wrote in message
news:1193315025.547896.15120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have to query Oracle database from SQL server 2000. But I do not
want to create linked server in SQL server 2000. I tried the
opendatasource as following.

SELECT * FROM OPENDATASOURCE( 'MSDAORA.1',
'Data Source=ORA;User
ID=username;Password=password' )..Clarity.GOAL_TYPE

I got error on that. however, I can get data from Oracle in MS access
with ODBC. Do es anyone have experience to retrieve Oracle data from
SQL server?
Thanks.



.

Relevant Pages

  • Re: load data from Access to SQL
    ... FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', ... Columnist, SQL Server Professional ... "Al Reid" wrote in message ... > recordset, but am unsure how do the Insert, without having to loop through ...
    (microsoft.public.vb.database.ado)
  • Openrowset Jet OLEDB
    ... we're having trouble using OpenDataSource with Jet OLEDB ... The task was to import a mdb into Sql Server. ... opendatasource from within the frontend app? ...
    (microsoft.public.sqlserver.security)
  • Re: OPENROWSET/OPENDATASOURCE
    ... If I grant the user executing the ... "Ad hoc access to OLE DB provider 'MSDAORA' has been denied. ... > FROM OPENDATASOURCE( ... > See details of both command in sql server books online. ...
    (microsoft.public.sqlserver.security)
  • Re: OPENROWSET/OPENDATASOURCE
    ... FROM OPENDATASOURCE( ... See details of both command in sql server books online. ...
    (microsoft.public.sqlserver.security)
  • Query Oracle database without linked server
    ... I have to query Oracle database from SQL server 2000. ... want to create linked server in SQL server 2000. ... SELECT * FROM OPENDATASOURCE('MSDAORA.1', ...
    (microsoft.public.sqlserver.connect)
Loading