Re: Link Server

From: Marcelo Colla (mcolla@bol.com.br)
Date: 09/09/02 

From: "Marcelo Colla" <mcolla@bol.com.br>
Date: Mon, 9 Sep 2002 14:32:32 -0300

Wy don't you try to especify the catalog name, like
linkedserver.catalogname.owner.table ?, I think that is this ? does Oracle
works with catalog ?, becouse if does you can use the same query for both. I
think that I can help you. Any another douts our suggestions please send me
one email to mcolla@bol.com.br. Regards. Marcelo Colla
"Praetorian Guard" <praetorian@gatekeeper.com> wrote in message
news:u#IfpIaVCHA.2452@tkmsftngp09...
> Hi,
>
> I had successfully link a SQLBase 7.5.1 and Oracle 8i database using MSS's
> link servers but my problem is when executing a select on the SQLBase
> database I got this error. I execute the same sql statement in Oracle and
it
> work fine. I already execute it on SQLBase itselft and I don't encounter
any
> error.
>
> Below is the Select statement
>
> Oracle
> -------
> Select * from Oracle..owner.table
>
> SQLBase
> ----------
> Select * from SQLBase..owner.table
>
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE DB
> provider 'MSDASQL'.
> [OLE/DB provider returned message: [MERANT][ODBC SQLBase
> driver][SQLBase]00902 PRS MFC Missing FROM clause]
>
>
> Thank you in advance.
>
>

Relevant Pages

  • Link Server
    ... I had successfully link a SQLBase 7.5.1 and Oracle 8i database using MSS's ... I already execute it on SQLBase itselft and I don't encounter any ...
    (microsoft.public.sqlserver.security)
  • Re: Link Server
    ... > I had successfully link a SQLBase 7.5.1 and Oracle 8i database using MSS's ... I execute the same sql statement in Oracle and ... I already execute it on SQLBase itselft and I don't encounter ...
    (microsoft.public.sqlserver.security)
  • [NEWS] Multiple Vulnerabilities in Oracle Database (Trigger, Extproc, Wrapped Procedures, PL/SQL Inj
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the Oracle database server. ... Oracle Trigger Abuse ... written in PL/SQL and execute with the privileges of the definer/owner. ...
    (Securiteam)
  • Re: Debug ORA-03113 on Oracle XE
    ... a laptop that runs the Oracle 10g Express ... The query returns no rows with the current data set but it's pretty ... If Oracle XE generates further info I don't know where I ... Usually, when you install Oracle, the UTL_FILE package is installed, EXECUTE is granted to PUBLIC, and a public synonym is created. ...
    (comp.databases.oracle.server)
  • Best practise for distributed transactions and oracle procedures.
    ... Execute a Stored Procedure to return a recordset of IDs from a SQL2K DB ... Then call a oracle procedure that will validate these ids against its ... Insert these exceptions into a exception table in our SQL2K DB. ...
    (microsoft.public.sqlserver.dts)
Quantcast