>I'm using ADODB recordsets with "oRs.AddNew()" syntax. It won't accept anything I'd normally use as a logical value. As long as the field list and value lists have no logicals, everything works properly.
>
>I get an OLE Dispatch exception Code 0 from MS OLEDB Provider for ODBC drivers. Multple step.... etc.
>
>>If you're talking about SPT, than 0/1 should work. Can you provide more details?
>>
>>>Ok, I give up. How do I send a logical VFP value to a MSSql 2005 bit field.
>>>
>>>.T. and .F. don't work, 1 and 0 don't work, and even though SQL Server says it will take the string values of 'True' and 'False' (and it will in Management Studio), they don't work from VFP either.
Why not run the SQL Profiler and see what happens?
I think 1/0 should work with this (never worked with ADO directly).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.