I'm running VFP 6.0 (Visual Studio Service Pack 3), on Windows NT (with service pak 4) and am getting an error that I just can't figure out.
I'm appending records from a foxpro table to a dbase table via a remote view and ODBC connection. The append works fine until it hits record 280 in the foxpro table. I get an error trying to insert a record into the dbase table at this point, specifically with respect to a date field in the dbase table. The date I insert is a converted string (CTOD function) from the FoxPro table, which works fine for all the records until the 280th. The string in the Fox Pro table seems fine (I've closely scrutinized it and even cleared the field and inserted a completely new value). I get this error for all records after 279, (i.e. I've bypassed record 280, 281, etc. with clean runs and still get the error). I do not get the error if I bypass getting the data from the foxpro table, e.g. passing a variable instead of data from the table. The error reads:"Connectivity Error[Microsoft][ODBC dBase Driver]Datatype mismatch in criteria expression." At this point I can't exit Fox Pro without an End Task from NT. Are there any known new ODBC errors introduced with Visual Studio Service Pak 3? Does this sound like an ODBC, code, or data problem? Any ideas?