Invalid object name 'xxx.PersonInfo'.

[moni]

Hi,

I am using a table named PersonInfo in my database monisha in the SQL
server.
I need to use this in a .aspx file , but its giving me the error of
invalid object name.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ConnectionStrings:monishaCS%>"
SelectCommand="SELECT [ID], [Name], , [PhoneNumber]
FROM [monisha.PersonInfo]">
</asp:SqlDataSource>

I have used it like that. Don know where I am going wrong. monishaCS
are my connection strings in my web.config file.

Pleassse help.
Thanks alot!

 

[Guest]

Likely that the connection string is pointing to a database which doesn't
have the table monisha.PersonInfo. Also, try your query without the owner
name 'monisha', in case it has changed.