"Invalid Object Name" 1

[jl280328]

I am trying to pull information from a SQL database using C#. Here is the code that I am using:

Conn = new SqlConnection( @"Server=WEBSERVERW2K; UID=sa; PWD=39x9iVu1; DataBase=Dealer Quoter Dev;" );
				Conn.Open();
				SQL="SELECT * From ReportGlue";
				Comm = new SqlCommand( SQL, Conn );
				SQLReader = Comm.ExecuteReader();
				Conn.Close();

However I keep getting an error stating that there is an "Invalid Object Name" and it refers to the table name 'ReportGlue' I was just wondering what could be causing this, because the tablename exists in the DB and the page will render if I comment out this line

SQLReader = Comm.ExecuteReader();

 

[ca8msm]

However I keep getting an error stating that there is an "Invalid Object Name"

What type of error? Is it a SQLException or a .NET error?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jl280328]

SQL Exception

System.Data.SqlClient.SqlException: Invalid object name 'ReportGlue'

 

[jbenson001]

Then that table does not exist in the DB you are querying

 

[ca8msm]

Or the user you are accessing the database as doesn't have access to the table.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.