cache and detailsview, all data controls problem

[TdarTdar]

Hello,
I enabed caching on my sql 2k database for the database and table as
stated in the
http://msdn.microsoft.com/msdnmag/issues/06/02/WickedCode/default.aspx
article here, however since then I am no longer able to drag tables or add
any data object or data source, if i drag the control in from the tool box
the screen flashes then there is nothing, no control dragged in, is there a
step that I am missing, do you have to enable cacheing on every table(I hope
not) or is there a security probem.

Steps i tried to undo the problem, I removed the .cs code file and also the
cache info in the web.config, including the connection strings (thinking that
maybe it was something in the projects code) and it still does not work, only
other step would be to disable the caching feature but not sure the reverse
command of:

aspnet_regsql –S localhost –E –d Mydatabase -ed
aspnet_regsql –S localhost –E –d Mydatabase –t SiteMap -et

However I would like to keep the data caching feature and solve/fix this
problem so i can get back to developing again.

David

 

[Luke Zhang [MSFT]]

Hello David,

Can you explain more how you enable the caching in the database? Also, will
the problem sitll occur if you start a new solution and connect to a
different database on the same SQL server?

Luke

 

[TdarTdar]

Hello,
I went ahead and did a new project and used the pubs database
and it works fine, and then i added something from the main
database that had the problem it that worked in the new project.

I went back to that main webproject and tried to put something from
the pubs database and it did not work. UGHH...

So I deleted the web.config and tried to add a dragged table and it
worked.

So I decided to try to find what caused the problem so I started
eliminating stuff from the bad web.config.

Now this is a bug ...

if i removed this:
<location path="USERS/MyLinks/">
<system.web>
<authorization>
<allow roles="USERS"/>
<deny users="*"/>
</authorization>
</system.web>
</location>

it worked fine ...

turns out that if you have "/" in the location line of

<location path="USERS/MyLinks/">

it breaks the drop and drag from the database and the other wizards

So
<location path="USERS/MyLinks">

works fine.

I also reproduced this with a different location statement
when i add the / at the end of the path it breaks the data wizards

Maybe someone could fix that or put in a error message
so people know what happened when they draged in
the table as opposed to doing nothing but not working.