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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Server (Oracle) Problems Accessing

Status
Not open for further replies.
eradtke

eradtke

Programmer
Apr 10, 2002
14
US
Oracle V7.3.4 DB setup as a linked server.

When I try to run the query
select * from tsserver...witems
I receive this:

OLE DB provider 'tsserver' does not contain table 'witems'. The table either does not exist or the current user does not have permissions on that table.

I have the correct security setup and also am able to browse the tables and run querys in enterprise manager.

Is there some naming convention I need to use in specifying the table to ensure it is using the correct schema in Oracle?
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
568
Volvere
V
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
700
gmmastros
gmmastros
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
141
pjw001
pjw001
tn_sudheer
  • Locked
  • Question
Accessing data from database between given time stamps
Replies
11
Views
271
Andrzejek
Andrzejek
wsjames
  • Locked
  • Question
Accessing VFP 9.0 Flat Tables
Replies
1
Views
111
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top