cfinsert works with mySQl 5 but NOT with ms sql server 2005

["masticwarrior" <webforumsuser@xxxxxxxxxxxxxx>]

First i would consider myself an "advanced" beginner at coldfusion.

 I had a setup of coldfusion 8 with mySQL5 w/GUI interface. I do my development 
in eclipse.

 I wrote a VERY simple code,  with a simple database table, and it submitted 
the data fine no problems. (i verified the data and it was indeed submitted)

 <cfif IsDefined ("form.posted")> 
    <cfinsert datasource="cfsales" tablename="test"> 
 </cfif> 


 <cfform format="flash" preloader="false">
 <cfinput name="fred" label="fred" type="text" width="100">
        <cfinput name="jones" label="jones" type="text" width="100">
        <cfinput name="submit" value="submit" type="submit">
 </cfform>
 <cfdump var="#form#">

 NOW im being FORCED to use MS SQL Server. so i wiped out everything (mySQl, 
All projects deleted from eclipse, All databases re-added properly in 
coldfusion administrator)

 now i CAN get data from the MS SQL database but i can not place anything into 
it.  

 NOTE: i re-created tables and columns and database names are EXACTLY the same 
as with mySQL. i re-wrote my code correctly too.(i think) SAME CODE AS ABOVE.

 datasource=cfsales table=test columns=fred,  jones

 cfdump shows data collected from form correctly.

 Is there additional code to place for MS SQL server that i dont know of?

 thanks in advance.
 What the heck could be wrong?