invalid object name SqlClientException !!!

[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

 

[Lloyd Sheen]

Make sure your connection maps to the correct database or ensure that the
SQLConnection has the correct database.

Lloyd Sheen

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

supports Post Alerts, Ratings, and Searching.