Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When I add an Oracle server as a Linked Server in SQL Server 2008 Management Studio, I can only see a database named 'default', and none of the other DB's on the server. Using Microsoft OLD DB Provider for Oracle or Oracle Provider for OLE DB--same result.

I map my local login to the remote user for the Oracle server, so it should not be a permissions issue.

Thanks for any ideas.

share|improve this question
add comment

2 Answers

Depends on what permissions are granted to the schema you're connecting to on the Oracle side. Have you applied latest patches to your Management Studio client?

share|improve this answer
    
I don't think it's a permissions issue... if I log into an Oracle DMBS tool I can see all the DB's I'm supposed to. Using the same credentials with the server linking, I only see the one default db. I believe my Mgmt Studio is up to speed--this seems to be a provider or provider config issue, don't you think? –  theog Jul 22 '09 at 22:27
add comment

This may sound like a dumb follow-up question, but is this a 64-bit instance of SQL Server that you've created the linked server for Oracle on?

share|improve this answer
    
Not dumb at all, Tim--thank you for your time in weighing in. The answer is no, I'm dealing with all 32-bit versions. For now, the RDBMS integration I need is working via some OpenQuery queries (4-part name queries don't work well against non-SQL-Server RDBMS), so it's not a huge problem. The SQL-Server-to-Oracle linking is working, just not looking the way I would expect. –  theog Jul 31 '09 at 22:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.