Assorted Frustrations

In a DNN site I was experiencing odd behavior on one the projects I was trying to get working properly.  I could not logon to the host account. I would return the error "You must specify a non-autogenerated machine key to store passwords in the encrypted format.".  The fix was that it needs the original machine key section in the web.config.  The validation key and the decryption keys are in a hex format string 1-0, and A-Z. I replaced the original content with placeholders "mKey" and "dKey" since I do not want to make public my keys... Look for soemthing like this <machineKey validationKey="mKey" decryptionKey="dKey" decryption="3DES" validation="SHA1" /> This post explains in more detail : http://kx.cloudingenium.com/programming/net/you-must-specify-a-non-autogenerated-machine-key-to-store-passwords-in-the-encrypted-format-either-specify-a-different-passwordformat-or-change-the-machinekey-configuration-

Answer that worked. INSERT rd_scs_only_clients select * from ( SELECT DISTINCT en . clientid_c FROM cd . enrollments en WHERE en . agency_c in ( 'SCCR' , 'SCRP' ) AND DATEDIFF ( DAY , GETDATE (), startdate_d ) > 90 EXCEPT SELECT DISTINCT en . clientid_c FROM cd . enrollments en WHERE en . agency_c not in ( 'SCCR' , 'SCRP' ) ) DATA http://stackoverflow.com/questions/11941188/how-to-insert-into-a-static-table-using-except

Could not get the damn objRs.MoveFirst() to work, it would error out with "Rowset position cannot be restarted." no matter what combination of cursor type and locking I had. ....snip  Set objRS = Server.CreateObject("ADODB.Recordset")  Set objRS = objCommand.Execute 'http://stackoverflow.com/questions/14122308/rowset-does-not-support-scrolling-backward ....snip If Not objRs.EOF Then     Do While Not objRs.EOF         CLIENTCOUNT_TOTAL = CLIENTCOUNT_TOTAL + 1         objRs.MoveNext()     Loop     'objRs.MoveFirst() 'orig     'did it this way 'http://www.webassist.com/forums/posts.php?id=22249 to use the close and reopen     objRs.Close     Set objRS = objCommand.Execute 'added since i was getting an error  "Rowset position cannot be restarted." End If

  ADODB.Command 8 21 error ' 8 800a0bb9 8 ' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Put this at the top.  Learned from a stackoverflow post.    <!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.6 Library" UUID="{00000206-0000-0010-8000-00AA006D2EA4}" VERSION="2.6" -->