I have uploaded a site with database on smarterasp.net Hosting and I have created RSS page for the site but when I try to access this page this error appears:
Invalid object name 'tblRSS'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name '
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
[SqlException (0x80131904): Invalid object name 'tblRSS'.]
my code is :
Dim dt As DataTable = New DataTable()
Dim conn As New SqlConnection("Data Source=SQL7002.site4now.net;Initial Catalog=DB_?????????;User Id=?????????_admin;Password=???????????;")
Dim ad As SqlDataAdapter = New SqlDataAdapter("SELECT * from tblRSS", conn)
I'm sure the tblRSS table exists, can you help me?