Hmm... Could you post exactly your code here?

This work for me, from VFP command, and from VB.NET:

cnnVFP = CreateObject("ADODB.Connection")
VFPDirectory = "c:\foxwork\vfpapps"

cnnVFP.Open("Provider=VFPOLEDB.1;Data Source=" + VFPDirectory + ";Collating Sequence=MACHINE")

cnnVFP.Execute("create table test (date_test D, dt_test T)")
cnnVFp.Execute("insert into test values (DATETIME(), DATETIME())")
cnnVFP.Execute("insert into test values ({^2006-10-10 11:11:11 PM}, {^2006-10-10 11:11:11 PM})")

>>Did you try:
>>
>>INSERT INTO mytable (created) VALUES ({^2006-10-10 11:11:11 PM})
>
>
>Still get a "Data type mismatch".