Craig,
here are some instructions for ColdFusion 5.0:http://dbforums.com/arch/114/2001/10/174934>From your post, MyODBC might be the problem.
hth,Judas.