invalid object name SqlClientException !!!

  • Thread starter Thread starter SqlJunkies User
  • Start date Start date
S

SqlJunkies User

Hi All,
I am very new to this ADO.net.
I installed MSDE,VS.NET on WIN2000 and I passed the database connectivity hurdles.
When I run a simple select statement I am getting an error as "invalid object name SqlClientException !!!", and when I do a count(*)on the table or @@SERVERNAME/db_name(), I am getting the +ve result whereas the table is existing in the database.
Can some one help me with this :::
my Sql Statement is like this
" Select Name,Email,Address from Employee " and even i tried
" Select Name,Email,Address from [Employee] "

Any help is greatly appreciated in advance.
Thanks,
bulbul
 
Make sure your connection maps to the correct database or ensure that the
SQLConnection has the correct database.

Lloyd Sheen

SqlJunkies User said:
Hi All,
I am very new to this ADO.net.
I installed MSDE,VS.NET on WIN2000 and I passed the database connectivity hurdles.
When I run a simple select statement I am getting an error as "invalid
Click to expand...
object name SqlClientException !!!", and when I do a count(*)on the table or
@@SERVERNAME/db_name(), I am getting the +ve result whereas the table is
existing in the database.
Can some one help me with this :::
my Sql Statement is like this
" Select Name,Email,Address from Employee " and even i tried
" Select Name,Email,Address from [Employee] "

Any help is greatly appreciated in advance.
Thanks,
bulbul
Click to expand...
supports Post Alerts, Ratings, and Searching.
 
Back
Top