Creating Linked Server in SQL Server reports an Error

Asked By baconpeter1 10 points N/A Posted on - 09/04/2011

Hi Friends,

I am facing a problem in creating a Linked Server. I explained my work in steps, for ease to find a solution.

1: Expand Security Node;

2: Right Click Linked Server Node;

3: In General Tab, Provide Name for Linked Server: MYLS;

4: Click Other Data Sources option;

5: Select Provider: Oracle Provider for OLE DB;

6: Product Name: Provide ORCL (Service Name of Oracle that I kept during installation);

7: Data Source: ORCL;

8: Provider String: Provider=MSDAORA.1; Password=tiger; User ID=scott; Data Source=ORCL; Persist Security Info=True;

9: Click OK, Expand MYSL Node, click Table/View Option then it reports following error “Error 7399: OLE DB provider ‘OraOLEDB.Oracle’ reported an error”.

SQL Server Enterprise Manager

Error 7399: OLE DB provider 'OraOLEDB.Oracle' reported an error.

OK

• Status: Open
• Question Views: 1728
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Thomas.Anderson

Go To Solution

Best Answer

Best Answer

Answered By Thomas.Anderson 5 points N/A #121531

Creating Linked Server in SQL Server reports an Error

Hello Dear friend,

I miss some information about your problem but I guess from the picture that you are trying to create a linked server from Microsoft SQL server to an Oracle server, or Oracle database. I guessed also, that you are using Microsoft SQL server 2000 that according to my experience, with the GUI for Microsoft SQL server.

 

I searched the Internet to find a document or a trusted solution for you, as I hate to waste time with solutions, that cause further errors than fixing an existing error. For this reason, I found that using a solution provided by Microsoft is more helpful.

 

So here is a link to the solution: solution here

 

I hope it can help you.

 

Regards,

 

Thomas

About Thomas.Anderson

Questions
0

Answers
3

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/14/2011
• Question Category: MS SQL Server

Answered By reynz 0 points N/A #121532

Creating Linked Server in SQL Server reports an Error

Dear friend,

I don't have any information about your problem. I searched the Internet to find a document  for you.So I found that using a solution provided by Microsoft is more helpful.

 

I hope this link is the solution : solution here

 

Trustful friend,

 

Reynz

About reynz

Questions
0

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/20/2012
• Question Category: MS SQL Server