Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ankurgupta26
Starting Member
32 Posts |
 Posted - 2003-02-21 : 00:47:20
|
| hii have created a linked server to oracle db using Enterprise manager(EM). Using EM I can see ALL the tables that are present on that oracle server.but when i write a sql query to access records from one of the tables in the linked server (which is visible in EM ) I am getting the following error.Server: Msg 7306, Level 16, State 2, Line 1Could not open table '"sapide"."s076"' from OLE DB provider 'MSDASQL'. The specified table does not exist.[OLE/DB provider returned message: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist]Have i missed any steps in configuring the server so that i can access data from that server.Infact i tried the following query using the openquery method and it works - ide is the linked server nameselect * from openquery(ide,'select count(*) from sapide.mdkp')But when i use plain select clause i get the above err msgselect count(*) from ide..sapide.mdkpIs something wrong wth my syntax ??Thanks !AnkuR.Edited by - ankurgupta26 on 02/21/2003 03:37:32 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-02-22 : 16:58:45
|
| Tryselect count(*) from ide.sapide..mdkp==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
linked server error