Re: Is there an equivalent to MS SQL "Linked Server"
Travis,
I'm not sure how you got this working, I've been pounding away at it for an hour or so
with no luck. I'm able to query using the OPENQUERY statement, but I can't figure
out the direct reference syntax...
This works and retuns a valid result set:
SELECT * FROM OPENQUERY(BILLPAY, 'SELECT * FROM STATECODE')
The *same* query using a direct reference fails:
SELECT * FROM BILLPAY...STATECODE
Invalid schema or catalog specified for provider 'MSDASQL'.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.]
I see you have a 'db Owner' in your direct reference. How did you go about establishing that?
Thanks,
Peter
Subject
Written By
Posted
Re: Is there an equivalent to MS SQL "Linked Server"
May 24, 2005 05:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.