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 |
|
gbaia
Yak Posting Veteran
52 Posts |
 Posted - 2004-04-28 : 09:16:48
|
| Hello!I'm trying to select / update something a DB on my web-server from my local server.I created the linked-server and everything is fine. i had bugs on the way that I managed to fix... However, now it's long time that I get the following error:OLE DB provider 197.45.234.9' does not contain table 'Images.dbo.Pictures'. The table either does not exist or the current user does not have permissions on that table.It doesn't make sense as the user id I'm using is on the database Images and he has full update select rights on all the tables (including the Pictures table).Any ideas?Thank you so much!!!! :-)Grazi |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-28 : 10:29:20
|
| This isn't a bug, this is an error... Can you see any other objects in the database? |
 |
|
|
gbaia
Yak Posting Veteran
52 Posts |
Posted - 2004-04-28 : 12:43:39
|
| No, none... everything I try to select / update brings this same error.Thanks!Grazi |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-28 : 12:52:15
|
| Then the user you are logged in as doesn't have select permissions on the object you are looking at... |
|
|
|
gbaia
Yak Posting Veteran
52 Posts |
Posted - 2004-04-28 : 13:04:58
|
| Thanks a lot. I wasn't sure and I didn't want to bother the web-server guy. I'll contact the him as it appears that the user can do everything on the tables, but, not on the columns of the tables and I dont' have the permissions to change this myself. Grazi |
|
|
|
|
|
|
Updating web-server DB permission bug