>>Yes Gregory,
>>That is the problem. It works as if it is a date only value.
>>Cetin
>>
>
>
>Cetin,
>
>To exclude foxpro anomalies, I have tried it with vbs and I can confirm that vbs also loses the time part.
>
>
>
>We cannot blame it on foxpro. VBS is also wrong
>Now, if .net works it cannot be VFPOLEDB
>
>So, I'm intrigued where it goes wrong. I believe both vfp and vbs pass a VT_DATE
>
>

>WScript.Echo Now()
>
>
>
>Set loCon = Createobject("AdoDb.Connection")
>Set loCmd = Createobject("Adodb.Command")
>
>loCon.ConnectionString="Provider=VFPOLEDB;Data Source=D:\Project9\Parse\Data\tmp.dbc"
>
>loCon.CursorLocation= 3    'adUseClient
>loCon.Open()
>loCmd.ActiveConnection=loCon
>loCmd.CommandText="insert into Test (f1, f2) values (123,?)"
>
>Set loParm = loCmd.CreateParameter("f2")
>
>loParm.Type = 135 
>
>loParm.Value = Now()
>
>loCmd.Parameters.Append( loParm )
>
>loCmd.Execute()
>
>loCon.Close
>

Thanks for trying in VB. I still blame on foxpro because if I do it against SQL server using SQLOLEDB, SQLNCLI driver the time part is included. It is not how VFP passes it, it is not VFPOLEDB then who is guilyty? Me for sure trying to use it from VFP:)
Cetin