Archive for 'ASP.NET'

Had a problm with ASP.NET applications generating an Access Denied exception when trying access system.servicemodel.

Turns out this is a problem with Plesk on Windows, and fortunately has a simple fix.

Log in as Administrator and execute the following:

cacls C:\Windows\assembly\GAC_MSIL /E /R psacln /T /C
cacls C:\Windows\assembly\GAC_MSIL /E /R psaadm /T /C
This came from this KB article and fixed the problem for me anyway.

http://kb.parallels.com/8576

Using SQLite with C#

Ive created a .NET Wrapper around SQLite which can be downloaded from Here

 

The example creates an example Server which allows clients to connect to it and execute queries.

This is proof of concept code only – It doesnt install as a windows service.

 

Extract the contents of the zip file to a folder. Run SQLiteDemoServer.exe Now run the following command: .

telnet localhost 1235 This will start a telnet session to the sqite server.

SQL can be sent as plain text. a ; followed by newline causes the sql to be evaluated. Special Commands show databases; -Lists all of the databases on the server use -Connects to .

Download the Library from Here

Please note that all code and examples are provided “as is”, without any kind of warranty.