MySQL Forums
Forum List  »  Newbie

Re: Is there an equivalent to MS SQL "Linked Server"
Posted by: Peter Motyka
Date: May 24, 2005 05:06PM

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

Options: ReplyQuote




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.