SqlDataSource - strange error (to me at least) ;-)

[J. Jespersen]

Hi all,

Have been using SqlDataSources for a while now. Reinstalled machine last
week, now running Server 2003. Installed both SqlServer 2000 and 2005 with
instance-names "sql2000" and "sql2005". Also installed both Visual Studio
2003 and 2005. VS2005 is the Release Candidate, and SQL2005 is the September
CTP.

During SqlDataSource configuration wizard, i can test connection and all is
fine. I can see table names and views in the "query builder" thingie, but
once i do the "Test Query" things go bad. I get an "Invalid Object Name" on
the table from which the datasource should retrieve its data.

I have posted small video of me producing the error. Any input is welcomed.
I suspect the side-by-side 2000 and 2005 installation, but it _shouldn't_ be
a problem, should it?
The video is here: http://www.netkoder.dk/error.wmv


Again, thanks for any input.

J.Jespersen
Denmark

 

[Sahil Malik [MVP]]

J.Jesperson,

I have run into this issue myself. Note that if you actually specify the
query (i.e. type it in yourself), alongwith Schema information on the table,
you won't get the error anymore. It's probably either

a) A permissioning issue on the database.
b) The fact that VS2005 B2 seems to not understand that schemas can have
permissions too, and seems to ignore that important peice of the puzzle.

Frankly speaking I didn't diagnose this error too much at my end, I simply
specified the query by hand and chugged along my merry way (because I had no
time to raise it to anyone), but I suspect it is "b", and it may even not be
fixed in RTM (Though I haven't tested this in RTM yet).

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx