| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-10-31 : 06:52:19
|
| hi,I am getting an error invalid object name xyz,(where xyz is a valid table in the database) does not exist ,but when I check the table from enterprise manager it is present there and when my web page tries to access it ,it says that table does not exist .what can be the possible problem?please help its kinda urgent.thnxs in advance.harsh. |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 06:55:40
|
| Are you including the user name to access the table? (eg dbo.table)? |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-31 : 06:57:52
|
| no. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 07:00:31
|
quote:
no.
Do you need to? |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-31 : 07:03:09
|
| If the user is a DBO owner then do I have to give the qualifier ?and the second thing the username and password are saved in a web config file which may be changed . |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 07:05:41
|
quote:
If the user is a DBO owner then do I have to give the qualifier ?and the second thing the username and password are saved in a web config file which may be changed .
that's what I mean. If the object is there but does not appear when you access it as your web user, you may need to prefix the table name with dbo. if dbo is the owner. Maybe. I'm just throwing out random things that I would try first. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 07:09:49
|
| Also I think I would try to log on through query analyzer as the web user, if you can, and see what you get in there.. eg check what database the user is in by default and suchlike. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-31 : 07:10:43
|
| actually I am using the same thing in all our other projects and in this case the project works fine with us but the same database is having problem on the clients side (I mean the client for whom we have developed the site for).can this be the login Id problem? unresolved logins? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-31 : 07:14:12
|
| Do you check to see if you are connecting to the correct database?If the user doesn't have permission on the database which he is trying to connect to he will often end up in master and without generating an error (this happens to most of the client connection services) and this would give an object not found.==========================================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. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 07:14:45
|
quote:
actually I am using the same thing in all our other projects and in this case the project works fine with us but the same database is having problem on the clients side (I mean the client for whom we have developed the site for).can this be the login Id problem? unresolved logins?
My guess would be logon / permissions type problems to be honest. I'd try to eliminate that and then try to eliminate the web side of things by running the queries yourself without using the web to see what differences there are.It's probably worth changing the user details since you said you can, just to see if you get better results as a different user. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-31 : 07:14:53
|
quote:
Also I think I would try to log on through query analyzer as the web user, if you can, and see what you get in there.. eg check what database the user is in by default and suchlike.
the problem is that I donot have the access to that database it is the remote database with the client.as i said earlier it works fine with us. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-31 : 07:17:41
|
| Does it behave as expected if you fully qualify the path to the objectdatabasename.owner.object?If it does, then I'd suggest the user context is wrong. If it doesn't, try a different user to see if it's that user behaving oddly. |
|
|
|
|
urgent help required on object not found error!