Why "Invalid Object Name"?

Discussion in 'Databases' started by Clay_Shannon, Apr 22, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I was able to locate the connection string of my newly provisioned database via the Control Panel login (I cannot access the email discountasp.net may have sent me).

    So I changed the connection string in web.config and uploaded it to my site:

    Old:

    <connectionStrings>
    <add name="KnowItAllDBConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\KnowItAllDB.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>

    New:

    <connectionStrings>
    <add name="KnowItAllDBConnectionString1" connectionString="Data Source=tcp:sql2k513.discountasp.net;Initial Catalog=SQL2005_489153_knowitalldb;User ID=SQL2005_489153_knowitalldb_user;Password=*****;"/>
    </connectionStrings>

    (where '*****' is my password).

    However, when I try to run my site, not only do I have to add "/default.aspx" to the URL for it to (try to) display, I get an err msg, namely:
    "Invalid object name 'TOP_SCORERS'. "

    TOP_SCORERS is one of my table names. How could it be an invalid object name?

    Or is there something else I need to do before this will work?
     
  2. I'd recommend a slight change in your connection string:

     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page