Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLEDB error when accessing data thru linked servers

Status
Not open for further replies.
vaidyanathanpc

vaidyanathanpc

Programmer
Nov 30, 2001
36
0
0
IN
Hello,
I have configured linked server on my SQL server (server1) to access data from a remote SQL server(server2). Both are SQL Server 2000. The linked server was setup without errors. I have checked the privileges on the objects being accessed and everything is fine.. Now when I try to access data from a table (table2 on database db2) in server2 such as

select * from server2.db2.dbo.table2

I get the following error..
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.

What could be the problem?

Thanks in advance
P.C. Vaidyanathan
 
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
145
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
176
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
59
Virendra Yaduvanshi
Virendra Yaduvanshi
tn_sudheer
  • Locked
  • Question
Accessing data from database between given time stamps
Replies
11
Views
106
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top