.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Joining tables

Posted By: Karthikeyan Anbarasan     Posted Date: December 29, 2010    Points:2   Category :Sql Server
How to join tables from a sql server and an oracle server and get result displayed in query analyser

Responses
Author: Deco             
Posted Date: December 29, 2010     Points: 5   

We cannot join different language's table

Regards,
Deco
Author: Pandian             
Posted Date: February 10, 2011     Points: 5   

Hi

- Implement LinkedServer to ORACLE from SQL Server.(Use "MSDAORA" provider for Oracle)
- Try to JOIN the databases using Four part naming convension.

Cheers
www.sqlserverbuddy.blogspot.com

If not I then who, If not now then when
Author: Maverick             
Posted Date: February 28, 2011     Points: 20   

Hello

You can use dblinks from orcale to connect to another oracle instance same way linked servers in sql..
But its not possible from oracle to sql or vice-versa.

Thanks,
Maverick
Author: sriram             
Posted Date: October 27, 2011     Points: 20   


we cannot join oracle Database to sql server DB because its different providers..

Regards
Sriram.R



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend