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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

How to Use SQL Server to Link to a Table in Oracle?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

How to Use SQL Server to Link to a Table in Oracle?

I have an Access DB that links to Oracle in pulls in the data I need.  I know Access quite well.  I am now trying to learn how to use SQL Server.  As a self-motivated training exercise, I am trying to get SQL Server to do exactly the same thing that my Access DB does.  I googled around for a solution on the web, and amazingly I didn’t find anything useful.  I thought there would be dozens of tutorials out there about this knid of thing.  Can someone please send me a link to a nice step-by-step tutorial for using SQL Server to link to Oracle?  Or, can someone give me step-by-step instructions about what to do?

I am using SQL Server Management Studio Express.

Thanks so much!!!




View Complete Post


More Related Resource Links

Oracle clustered table to MS SQL Server 05 SSIS

  
Hi Guys, Can the SSIS deal with clustered Oracle tables? Moreoever, what are clustered tables compared to partitioned tables? I cant find much about it. (only sytax how to create them). Thanks, metalray

Can't update table oracle using a liked server on sql server

  

I have a stored procedure in SQL2005 that updates data base oracle's tables by a linked server. When run into a transaction I get the following error message:

Msg 7391, Level 16, State 2, Procedure CSGICONTABILINS, Line 69

The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "LS_JBSQLT01_SGI_GLHI" was unable to begin a distributed transaction.

 


Can't update table oracle using a liked server on sql server

  

I have a stored procedure in SQL2005 that updates data base oracle's tables by a linked server. When run into a transaction I get the following error message:

Msg 7391, Level 16, State 2, Procedure CSGICONTABILINS, Line 69

The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "LS_JBSQLT01_SGI_GLHI" was unable to begin a distributed transaction.

 


copy data (table) SQL server to Oracle

  

I want to copy or transfer data SQL server to Oracle 10 G. any body can help me.

 


I can't link a Oracle 10 with a SQL Server 2008 R2

  

Hello, I am trying to migrate from a "SQL Server 2005" to a "SQL Server 2008 R2" on 64 bits. In my old SQL 2005, I have a link to a Oracle Server via MSDAORA "Microsoft OLE DB Provider for Oracle", but this option does not come in the new SQL Server 2008. I tried with the Oracle's provider, but does not work, and in this forums I read that I should use the "Microsoft OLE DB Provider for Oracle", How can I get "Microsoft OLE DB Provider for Oracle" for a "SQL Server 2008 R2" on 64 bits?

Thank you


JuanGN

Temporary tables in SQL Server vs. table variables

  
When writing T-SQL code, you often need a table in which to store data temporarily when it comes time to execute that code. You have four table options: normal tables, local temporary tables, global temporary tables and table variables. I'll discuss the differences between using temporary tables in SQL Server versus table variables.

Bulk Copy From Datatable To SQL Server Table

  

 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
    {
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;
        
        con.Open();
        bulk.WriteToServer(dt);
        con.Close();

        return true;
    }

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.

 


video tutorial link for composite and rendered custom server control

  

hii all

i am new to technology so go easy on this post

according to what i read from web there are 3 type of custom server controls

1 superclass

2 composite

3 rendered

i found video tutorial for superclass custom server control but couldnt find video tutials for other 2.

please forward me link for composite and rendered custom server controls video tutorial  


Under the Table: Programming with FileStreams in SQL Server 2008

  

There's always been disagreement about whether large blobs, such as document and multimedia items, should be stored in the database or file system. In SQL Server 2008 you don't have to choose; filestream storage provides the best of both approaches.

Bob Beauchemin

MSDN Magazine May 2009


Under The Table: Spatial Data Support In SQL Server 2008

  

New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009


generate create script of table using c# and SQL server 7.0, can anyone help me?

  


I want to generate create table script using c#.net, I want to connect sql server 7.0 and generate table create script. Its urgent kindly help me urgently.


Linq with two databases (oracle and sql server)

  

Hey,
i have a problem to bring the data from the oracle (external database) and the sql server together (with similar data). The linq entities are linked to each other. The structure is like different countries with different cities and so on. To display these "non original linq objects" i need to put them into entities (linked to each other). Now i add some of them to my sql database. But for every entity i must check the connection to the other objects i don't want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot, preg


sql server 2005 express - don't allow to create table

  
i have downloaded sql server 2005 Express version from the web and use domainname\SQLEXPRESS as server name but now i can't create table seems every create by sa user, what is the password of this user or how to grand right to my window login user so that i can modify/create something in database.

Creating a table-valued function on a user defined type in SQL Server CLR

  
We would like to be able to create a table-valued function on a user defined type.  We would like the syntax in SQL to look like it works for the XML nodes function:   DECLARE @myXml XML = '<a><b>1</b><b>2</b><b>3</b></a>' ; SELECT  node.query('text()') FROM    @myXml.nodes('a/b') nodes (node) ;   In other words, in the FROM clause, we can access the "nodes" method of the xml variable and it returns a rowset. Thanks!

Triggering an event to occur within a VB.NET app if something is inserted into an SQL Server table

  
Let's say SQL Server is inserting arow within a table. Is there a way to let VB.NET know that an event was fired (being the inserting of the row within the table), without the need to query anything. Bascially having SQL Server tell the VB.NET app that an event was fired. It seems like it might be possible using CLR and the .NET framework integration wthin SQL Server, but I haven't found a sample program showing what I'm attempting. I understand that this topic covers SQL Server and VB.NET.  This need being for both and this forum only set for SQL Server, I thought I'd take the risk and post in this forum. Thank you in advance for any assistance.Newbie

How to create a view in my database from a table in another server/database

  
Is there a way to create a view in my database referencing a table in another server/database if I have the connection information.  I know how to do it in Oracle, simply create a database link, but have never done so in sqlserver.

No Way to retrieve data from oracle ref:_cursor over T-SQL and linked Server?

  
Hello, for an migration projekt we want to compare results from sp's from oracle and sqlsserver. Same calls should retrieve same results. Also we want build an automatic test for this. But is there now way to retrieve results from oracle sp's whit rev_cursor over linked Server? No one answer to this: http://social.msdn.microsoft.com/forums/en-us/sqldataaccess/thread/2BAC6743-8701-4476-8F36-0377A5761525   greetings Michael
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

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