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 |
|
nati_nieves
Starting Member
4 Posts |
 Posted - 2002-04-26 : 06:26:10
|
| HiI've created a linked server from one server (server1) that it has Sql Server to other server (server2) that it is in Ingres, by ODBC with the data_source parameter. Now in the Query analyzer I execute the next:select *from ACTUALIZAR.BD2.usuario1.centroWhere ACTUALIZAR is the name of the linked server, BD2 is the data base, usuario1 is the owner and centro is the table. This user has all privileges but always appears this errors:Server: Msg 7313, Level 16, State 1, Line 1Invalid schema or catalog specified for provider 'MSDASQL'.Why? Can you help me?Then I execute in the query analyzer the next:SELECT * FROM OPENQUERY(ACTUALIZAR, 'SELECT * FROM CENTRO')and it's OK, but when I execute:update openquery(ACTUALIZAR, 'SELECT * FROM CENTRO')SET NOM_CENTRO = 'XXXX'WHERE COD_CENTRO = 1then it gives me the next error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: Insufficient base table information for updating or refreshing.]Why? This user has privileges of read and update. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-04-26 : 09:11:50
|
| I recommend reading BOL on linked servers using ODBC (using Catalog functions) for your problem of distributed query. I took a quick look and I think that the name of the server is enough to qualify the names of the tables and columns.The second error could be because the ingres ODBC does not support updates? |
 |
|
|
|
|
|
Linked Servers and Sintaxis