This picture is the setup I use with a DSLR Canon EOS Rebel. I have a 100mm lens and use two 45w daylight bulbs. I also have a remote release to help avoid camera shake. I have tried various settings on the camera, but so far have liked the preset macro setting the best.
I have David Busch's book on this camera and I also found the book by Mark Goodman (Numismatic Photography 2nd ed.) very useful.
I am still experimenting with settings and lighting though, but I am getting OK results so far.