Posted January 27th, 2010 by Wesley
When I stumbled upon this error “parameter @columnName has no default value”, first thing I tried was Google, of course. When googling, I found lots of answers for this problem, but they all resulted in the following solutions:
Parameter name is different in the query and when declaring the parameter (wrong columnName, or wrong parameter assigned [...]
Tags: ado.net, DbCommand, nullable, OleDbCommand, prepared statement
Posted January 14th, 2010 by Wesley
If you’re running Windows 7 and find that from time to time, you PC slows down for 5-10 seconds, try to monitor the System process (NT Kernel & System, or ntoskrnl.exe): chances are that this process is hogging the CPU. If it is, take a look at your network adapter(s) properties and check if LMHOSTS [...]
Tags: cpu, kernel, lmhosts, performance, system, windows 7
Posted March 12th, 2009 by Wesley
When you are (still) using ODBC or ADODB to update memo fields in a FoxPro table, you might run into the problem that all of your rows are updated instead of just the one when using AppendChunk. This is probably caused by the fact that memo’s are stored in a separate FPT file, organized in [...]
Tags: adodb, appendchunk, command, foxpro, memo, odbc