Type conversion required by the DataType error with a fresh install of Windows 11

[Nro]

I’ve updated my main dev machine to Windows 11. I’m accessing a SQL Server with a remote view based on an 32 bit ODBC driver. It was working ok with win 10 but now I receive the error message “Type conversion required by the DataType property for field ‘Ae_Debut’ Is invalid” It as date field and the SQL view is

DBSetProp(ThisView+".ae_debut","Field","DataType","D")
DBSetProp(ThisView+".ae_debut","Field","UpdateName","AgnMain.AE_DEBUT")
DBSetProp(ThisView+".ae_debut","Field","KeyField",.F.)
DBSetProp(ThisView+".ae_debut","Field","Updatable",.T.)

I did not change anything, the SQL ODBC version driver is the same as before and I have a virtual machine in Windows 8.1 (I know, I know) and it’s still working. In the SQL Server table, the Ae_Debut type is date

 

[Chris Miller]

Sure you're using the exact same version of the exact same series of MSSQL Server ODBC drivers? There are quite a lot.

It's been a while since MSSQL introduced date fields, it's still very typical to have datetime fields in SQL Server and that corresponds to VFPs T not D type.
I do understand you explicitly said the SQL Server table column is date. There still are drivers that don't support this SQL Server type, for example, but only pass back T.

Chriss

 

[mJindrova]

Hmm,

When VFP show the error?
What return SET("DATE")?
What are date values in a field on MSSQL?

MartinaJ

mJindrova