Last post Nov 23, 2012 01:07 AM by Vibhor Agarwal
Nov 23, 2005 03:27 PM|Joost Verdaasdonk|LINK
While doing a tutorial on cache dependency I ran into problems.
The error from the debugger was that my database was not setup for cache dependency.
So I searched on the web and found out you could use aspnet_regsql to fix that.
So I executed this from the cmd:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\aspnet_regsql.exe -S localhost\sqlexpress -E -d Pubs -ed
And I got this responce from the prompt:
Enabling the database for SQL cache dependency.
All looked fine I thought and I runned the app again.
Again the debugger called me back saying I had to setup the table for cache dependency as well.
So I called the prompt again and pasted in another command but it didn't work the prompt gave me:
C:\....aspnet_regsql.exe is not a valid win32 applicaition and in the prompt an: "Access denied"
I thougth how strange so I looked up the exe to start it up manualy.
Again I received the same error. (And a half hour ago the wizard (UI) still worked by doubleclicking the exe file.....)
Close examination of my Windows explorer showed that the exe has been changed 5 minutes ago. (The time I set SQL dependency on the pubs table...)
And to get more spooky the file is now only 0kb large???
So somehow I feel I killed this exe file and I have no clue on how to fix it. Perhaps I should reïnstall the Framework but I'm not sure if that is a wise thing to do.
Someone got a clue?
Nov 23, 2005 04:04 PM|eramseur|LINK
Nov 23, 2005 05:28 PM|Joost Verdaasdonk|LINK
You also have to set up your web.config to tell your app what you want to depend on.
Link will help : http://www.ondotnet.com/pub/a/dotnet/2005/01/17/sqlcachedependency.html
Nov 23, 2005 07:24 PM|eramseur|LINK
Nov 24, 2005 06:34 AM|Joost Verdaasdonk|LINK
Thank you for your answer.
Yes I have and I also added the correct page directives in the calling page (.aspx) as well.
Again I have to emphasis that the problem is with the aspnet_regsql.exe. After the successful setup for cache dependency on the pubs database the tool went dead.
If you double-click it then you are supposed to get a UI to change some general stuff on databases. But now (after using the tool to set cache dependency) if you
try to use it (by double-clicking it or by the cmd) you get the following error: “C:\....aspnet_regsql.exe is not a valid win32 application”
IMO this is telling me that the aspnet_regsql.exe is corrupted.
Like I said before the file size of the exe is now 0 kb and the change to that size has the time stamp of the usage of the tool to set cache dependency on the “pubs”
With that knowledge I’m sure the tools is broken and perhaps someone can tell me what is the correct file size of that tool. (cause mines 0 kb now…)
You say replace it with a new one? Do you have a copy of a working one for me? Or a download URL for just that tool?
Nov 24, 2005 07:36 AM|eramseur|LINK
Nov 24, 2005 08:22 AM|Joost Verdaasdonk|LINK
Sorry don't use that Tool.
I'm trying VWD Express for now with SQLExpress 2005 and if that works well I think about buying the full tool.
Any other downloading source?
Nov 24, 2005 08:17 PM|eramseur|LINK
Nov 25, 2005 05:45 PM|ScottGu|LINK
Nov 26, 2005 03:45 PM|Joost Verdaasdonk|LINK
Hi Eric and Scott,
Well the exe file is corrupt for sure but I don't think it has anything todo with a virusscan.
Like I mentioned in my first post it got corrupted setting the dependency on the database itself and after trying todo the same for the author tabel windows didn't recognize it anymore. (and the file was changed to 0 kb size)
I'm still running the Beta 2 versions of all products so I think it's time to upgrade to the final release that came out 7 november. (haven't had time to set that up but will soon)
Thanx to the both and I think reinstalling will fix the problem. I'll mark this one solved.
Nov 27, 2005 07:58 PM|Joost Verdaasdonk|LINK
Nov 23, 2012 01:07 AM|Vibhor Agarwal|LINK
I got the same problem yesterday. The tool ran fine two times but then the third time it stareed saying that it is not a valid Win32 application. I checked, the file size was 0KB.
Did you find any solution to this problem. I think reinstalling thw whole framework is not a good option.
*And the tool is not a part of any beta or express product suite. It was installed with VS 2010 Professional (with SP1).