Clearing ASP.NET caches via adp

[helveticus]

Hi, I have an ASP.NET 3.5 site where SQL Server management chores can
be duplicated via a dedicated MS A2k adp application (A2K still works
ok for my purposes).

Question. When SQL updates are carried out in site within the admin
section, caches are cleared using ASP.NET ad hoc cache deleting
functions (ie HttpContext.Current.Cache.Remove() etc.) Is there a way
to achieve the same effect via an adp application (web service,
etc.) ? TIA

 

[Sylvain Lafontaine]

ADP is connected to your SQL-Server and not to your web server. Anything
that will work on SQL-Server to access the web server will also work with
ADP but a SQL-Server is really not the place to do such administrative
chores.

From ADP, any VBA code that will connect to the web server - for example
calling a Web or a SOAP service - will work as well inside ADP as it would
inside any other scripting machine.

For the rest, I don't really understand what you mean exactly with the
expression SQL updates and under what context these updates are associated
to the ADP project file and I also don't understand why you would want to
make a second clearing of the cache (after these *updates* ?) if one has
already be made.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[helveticus]

Thanks for your reply. Retrospectively, the post seems to be indeed
somewhat confusing. I meant to say managing SQL Server related chores
via adp.

Currently, the site can either be managed internally (admin pages) or
externally via adp with the above restriction. Because Access is so
convenient and flexible, I tend to externalize more and more SQL
Server CRUD chores to Access whenever possible.

I was not aware of the fact that you could call Web or a SOAP services
within A2K adp. Could you by chance refer me some links to explore
this possibility? TIA.

 

[Sylvain Lafontaine]

The SOAP Toolkit 3.0 is available from MS:

http://www.microsoft.com/downloads/...DD-CEEC-4088-9753-86F052EC8450&displaylang=en

For the last version(s) of web services, MS doesn't offer support anymore
for any COM components, so you'll have to refer to .NET if you don't want to
develop your own custom solution. Shouldn't be a problem calling a .NET
library from Access; however, I don't see the point of trying to put
everything into an ADP project and if you really want to develop a full
solution, your best step would be to switch entirely to .NET.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)