By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
463,317 Members | 554 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 463,317 IT Pros & Developers. It's quick & easy.

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name on Linked Server

P: 4
Hi Folks,
I'm having a strange situation here between 2 Linked MS SQL 2K servers.
One of the servers died recently and I rebuilt it.
All seems to be working fine, except that when I create views that access tables on the other (linked) server, I can not modify any data, because I get the [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name server.database.dbo.TableName error.
The View does work fine otherwise, ie displays the data in it, I just can't modify.
The Linked Servers are done with the sa user between these 2 servers.

Any ideas what could be causing this error?
Sep 11 '06 #1
Share this Question
Share on Google+
2 Replies

P: 4
--- bump ---
no one ideas on this?
Sep 20 '06 #2

P: 1
I'm also having problems with this - mine is in relation to a labeler printer, it is present in my ODBC and the test is successful. However, when I go to print I get the following error: [microsoft][ODBC SQL Server Driver][SQL SERVER] Invalid object name 'table name' ODBC -- call failed

I can't seem to see what the problem is as my project server works from this client.
Oct 5 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.