This Old Code

sql ce / sql compact native error codes

Aaron Fischer — Mon, 30 Apr 2012 19:11:57 GMT

I found my self working with the new sql compact server and need a listing of native error codes. I couldn’t find them on msdn but I did find a sqlce_err.h file at code.google.com

http://interested.googlecode.com/svn-history/r7/trunk/SQLCEHelper/Include/sqlce_err.h

or http://code.google.com/p/interested/source/browse/trunk/SQLCEHelper/Include/sqlce_err.h

I found the sql ce error documented on msdn at http://msdn.microsoft.com/en-us/library/ms171849.aspx

This weblog is sponsored by MicroFisch.

Point Rule Require Gov monitoring when credit not received

Aaron Fischer — Thu, 15 Oct 2009 18:44:44 GMT

There was a message board question asking how to setup the logic of a point rule where the borrower sex had to be filled out under government monitoring when the credit report received date was blank.

It turns out you need at least two rules to do this(4 if you need co-borrower as well)

Below are the screen shots you need to set up the two rules.

Now the point user will have to have Borrower checked as male or female to pass this rule.

This weblog is sponsored by MicroFisch.

DLL Reference Assemblies Not Coping To Application

Aaron Fischer — Tue, 29 Sep 2009 13:19:49 GMT

I had an issue where one of the dlls referenced in my service layer would not copy into the application’s destination program. This seems to happen because there was no direct usage of this assembly in my service layer. In order to fix this I created a stub class that inherited from one of the classes in the needed assembly its a kluge but it saved me from build scripts and taking another dependency on from the application.

In this case the dll in question was NHibernate.ByteCode.Castle.dll

and the corresponding stub class was

NHibernateByteCodeStub : NHibernate.ByteCode.Castle.ProxyFactory {
}

This weblog is sponsored by MicroFisch.

Setting up NHibernate SQL Logging

Aaron Fischer — Thu, 17 Sep 2009 21:49:30 GMT

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<!-- Others sections -->
<section name="log4net"  type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>  <log4net>
<appender name="GeneralLog"  type="log4net.Appender.RollingFileAppender">
<file value="Logs.txt"/>
<appendToFile value="true"/>
<maximumFileSize value="100KB"/>
<rollingStyle value="Size"/>
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d{HH:mm:ss}
[%t] %-5p %c - %m%n"/>
</layout>
</appender>
<logger name="NHibernate.SQL"  additivity="false">
<level value="DEBUG" />
<appender-ref ref="GeneralLog" />
</logger>
</log4net>
</configuration>

and call

log4net.Config.XmlConfigurator.Configure();

from you application startup.

A more Official route.

Here is some HowTo from nhforge.org

This weblog is sponsored by MicroFisch.

Click Once

Aaron Fischer — Fri, 11 Sep 2009 16:17:35 GMT

Process.Start Method (String, String, SecureString, String)

process has a way to take a secure string

ProcessStartInfo myProcess = 
   new ProcessStartInfo("my.exe");

myProcess.UserName = "...";
SecureString password = new SecureString();
password.AppendChar('1'); // repeat
myProcess.Password = password;
myProcess.UseShellExecute = false;
Process.Start(myProcess);

ClickOnce Deployment for Visual C++ Applications

Deploying MFC applications via ClickOnce

Easy-to-use resumable .NET file downloader

Using BITS

Background Intelligent Transfer Service (BITS)

This weblog is sponsored by MicroFisch.